{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Inputs","Impacts","Options","TripGen","TruckImpacts","TruckDistribution","RoadwayConstants","RoadwayCalcs","BridgeConstants","BridgeCalcs","OtherRoadway"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":110,"n_cols":9,"rows_kept":110,"cut":false,"hidden":false,"merged":[[75,6,75,7],[6,6,6,8],[14,6,14,8],[58,6,58,7],[63,6,63,7],[35,6,35,8],[37,6,37,8],[39,6,39,8],[48,6,48,8]]}
["CDOT Oil & Gas Impacts Calculator"]
["Created by Felsburg Holt & Ullevig for exclusive use by CDOT"]
["v1.2","Last updated on 3/2/2015"]
["Roadway Information"]
[]
["SEGMENT:",1]
["Q1.","Name of the roadway:"]
[]
["Q2.","Start Mile Post:"]
[]
["Q3.","End Mile Post:"]
[]
["Q4.","CDOT Region:",null,null,null,null,"R1"]
[]
["Q5.","Functional Class:",null,null,null,null,"Interstate"]
[]
["Q6.","Urban or Rural?:",null,null,null,null,"Urban"]
[]
["Q7.","Mountains or Plains?:",null,null,null,null,"Plains"]
[]
["Q8.","Segment Length (miles):",null,null,null,null,{"$f":"ABS(G11-G9)","v":0},"mi"]
[]
["Q9.","Surface Type:",null,null,null,null,"Asphalt"]
[]
["Q10.","Paved Width (feet, total of both directions):",null,null,null,null,null,"ft"]
[]
["Q11.","# of Through Lanes (total of both directions):"]
[]
["Q12.","Drivability Life (years remaining):",null,null,null,null,null,"years"]
[]
[]
[]
["Bridge Information"]
[]
["BRIDGE:",1]
["Q1.","Structure #:"]
[]
["Q2.","Facility Carried:"]
[]
["Q3.","Feature Intersected:"]
[]
["Q4.","Baseline Average Daily Truck Traffic (ADTT):",null,null,null,null,null,"trucks/day"]
[]
["Q5.","Bridge Width (feet):",null,null,null,null,null,"ft"]
[]
["Q6.","Bridge Length (feet):",null,null,null,null,null,"ft"]
[]
["Deck -"]
["Q7.","Deck Overlay Type:",null,null,null,null,"HMA/Membrane"]
[]
["Joints -"]
["Q8.","Bridge Joint Type:",null,null,null,null,"No Joints"]
[]
["Q8a.","# of Joints along Bridge:"]
[]
["Q8b.","Joint Skew (no skew = 0 deg):",null,null,null,null,0,"deg"]
[]
["Bearings -"]
["Q9.","Bridge Bearing Type:",null,null,null,null,"No Bearings"]
[]
["Q9a.","# of Bearings:"]
[]
["Replacement Bridge -"]
["Q10.","Replacement Estimate Method:",null,null,null,null,"% Increase"]
[]
["Q10a.","% Increase in Replacement Bridge Area:",null,null,null,null,0,"%","(100% of the existing area will automatically be added)"]
[]
["Q10a.","Replacement Width:",null,null,null,null,{"$f":"G44","v":0},"ft"]
[]
["Q10b.","Replacement Length:",null,null,null,null,{"$f":"G46","v":0},"ft"]
[]
[]
[]
["Activity Settings"]
[]
["Q1.","What is the type of development?",null,null,null,null,"Horizontal"]
[]
["Q2.","Is a pipeline providing fresh water?",null,null,null,null,"No"]
[]
["Q3.","# of DEVELOPING Pads and Wells to Analyze:",null,null,null,null,"Pad(s)",null,"Well(s)"]
[]
[null,"(wells are the total # across all pads)",null,null,null,null,1,null,8]
[]
["Q3a.","Anticipated # of years of production:",null,null,null,null,20,"years"]
[null,"(Leave at 20 if unsure)"]
[]
["Q3b.","Anticipated length of development (days):",null,null,null,null,30,"days"]
[null,"(Leave at 30 if unsure)"]
[]
["Q4.","# of EXISTING Pads and Wells to Analyze:",null,null,null,null,"Pad(s)",null,"Well(s)"]
[]
[null,"(wells are the total # across all pads)"]
[]
["Q4a.","Estimated # of years of production remaining:",null,null,null,null,null,"years"]
[]
["Q5.","What % of trip types will be using the facility?"]
[null,"(Leave at 100% if unsure)",null,null,null,null,"%"]
[]
["WORK","Workers:",null,null,null,null,100,"%"]
["EQUIP","Construction equipment:",null,null,null,null,100,"%"]
["RIG","Drilling Rig & Support:",null,null,null,null,100,"%"]
["PIPE","Pipe:",null,null,null,null,100,"%"]
["GRAV","Gravel:",null,null,null,null,100,"%"]
["CEM","Cement:",null,null,null,null,100,"%"]
["FUEL","Fuel:",null,null,null,null,100,"%"]
["CHEM","Drilling Chemicals:",null,null,null,null,100,"%"]
["SAND","Sand:",null,null,null,null,100,"%"]
["F-WATER","Fresh Water:",null,null,null,null,100,"%"]
["P-WATER","Flowback Water Disposal:",null,null,null,null,100,"%"]
["OIL","Produced Oil:",null,null,null,null,100,"%"]

{"sheet":"Impacts","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[30,3,30,4],[19,4,19,5],[26,4,26,5],[10,4,10,5],[13,4,13,5],[13,2,13,3],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[22,2,22,3],[22,4,22,5]]}
["CDOT Oil & Gas Impacts Calculator - Impact Report"]
["Created by Felsburg Holt & Ullevig for exclusive use by CDOT"]
["v1.2","Last updated on 3/2/2015"]
["Roadway Impacts"]
["ID","Name","Start MP","End MP","Length","Surface","Development Costs ($2014)","Future Pad(s) Production Costs ($2014) / Year","Existing Pad(s) Production\nCosts ($2014) / Year"]
[]
[]
["TOTAL:",null,null,null,{"$f":"SUM(E6:E7)","v":0},null,{"$f":"SUM(G6:G7)","v":0},{"$f":"SUM(H6:H7)","v":0},{"$f":"SUM(I6:I7)","v":0}]
[null,null,null,null,null,null,"Total over years of production:",{"$f":"H8*$D$38","v":0},{"$f":"I8*$E$38","v":0}]
[]
["Total additional roadway costs over life of pad(s):",null,null,null,{"$f":"G8+H9+I9","v":0},null,"($2014)"]
[]
["Bridge Impacts"]
["ID","Structure #","Facility Carried",null,"Feature Intersected",null,"Development Costs ($2014)","Future Pad(s) Production Costs ($2014) / Year","Existing Pad(s) Production\nCosts ($2014) / Year"]
[]
[]
["TOTAL:",null,null,null,null,null,{"$f":"SUM(G15:G16)","v":0},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":0}]
[null,null,null,null,null,null,"Total over years of production:",{"$f":"H17*$D$38","v":0},{"$f":"I17*$E$38","v":0}]
[]
["Total additional bridge costs over life of pad(s):",null,null,null,{"$f":"G17+H18+I18","v":0},null,"($2014)"]
[]
["Total Impacts"]
[null,null,null,null,null,null,"Total Development Costs ($2014)","Total Future Pad(s)\nProduction\nCosts ($2014) / Year","Total Existing Pad(s)\nProduction\nCosts ($2014) / Year"]
[null,null,null,null,null,null,{"$f":"G8+G17","v":0},{"$f":"H8+H17","v":0},{"$f":"I8+I17","v":0}]
[null,null,null,null,null,null,"Total over years of production:",{"$f":"H9+H18","v":0},{"$f":"I9+I18","v":0}]
[]
["Total additional transportation costs over life of pad(s):",null,null,null,{"$f":"G24+H25+I25","v":0},null,"($2014)"]
[]
["Activity Settings & Totals"]
[]
["Type of Activity:",null,null,{"$f":"Inputs!$G$76","v":"Horizontal"}]
[]
[null,null,"Pad(s):","Future","Existing"]
["Total Pad(s):",null,null,{"$f":"Inputs!$G$82","v":1},{"$f":"Inputs!$G$92","v":0}]
[]
["Total Well(s):",null,null,{"$f":"Inputs!$I$82","v":8},{"$f":"Inputs!$I$92","v":0}]
[]
["Years of Production:",null,null,{"$f":"Inputs!$G$84","v":20},{"$f":"Inputs!$G$94","v":0}]
[]
["Total One-Way Development Trips:",null,null,{"$f":"TruckDistribution!$L$163","v":12370},"*"]
[]
["One-Way Production Trips (Annual):",null,null,{"$f":"TruckDistribution!$L$67","v":560},{"$f":"TruckDistribution!$L$75","v":0},"*"]
[]
["Total One-Way Production Trips:",null,null,{"$f":"D42*D38","v":11200},{"$f":"E42*E38","v":0},"*"]
[]
["*","Trips may have been reduced (through user settings) based on estimated % of trip types using the facilities."]
[null,"See the \"Inputs\" tab for settings used."]

{"sheet":"Options","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Lane Surface:","Development Type:","Roads:","Bridges:","CDOT:","Loc:","Functional Class:","Topo:","Deck Overlay:","Joint Type:","Bearing Type:","Replacement:","Pipeline:"]
["Asphalt","Horizontal",1,1,"R1","Urban","Interstate","Plains","HMA/Membrane","No Joints","No Bearings","% Increase","No"]
["Concrete","Vertical",null,null,"R2","Rural","Principal Arterial","Mountains","Polyester","Plug Joint","Type 1","Width/Length","Yes"]
[null,"Recompletion",null,null,"R3",null,"Principal Arterial - Others",null,"No Overlay","0-4 inch","Type 2"]
[null,null,null,null,"R4",null,"Minor Arterial",null,null,"Modular","Type 3"]
[null,null,null,null,"R5",null,"Major Collector"]
[null,null,null,null,null,null,"Minor Collector"]
[null,null,null,null,null,null,"Local"]

{"sheet":"TripGen","index":3,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,0,0,5],[14,0,14,5],[17,0,19,0],[20,0,26,0],[27,0,27,2],[39,0,40,0],[6,0,12,0],[3,0,5,0],[38,0,38,5],[13,0,13,2],[28,0,28,5],[30,0,36,0],[37,0,37,2]]}
["Horizontal"]
["Stage","Phase","Pad/Well","Raw Trips","Rounded Trips","Total Trips"]
["Construction","Pad and Road Construction","Pad",87,{"$f":"ROUNDUP(D3/2, 0)*2","v":88},{"$f":"IF(C3=\"Well\", E3*Inputs!$I$82, E3*Inputs!$G$82)","v":88}]
["Drilling","Drilling Rig","Pad",67,{"$f":"ROUNDUP(D4/2, 0)*2","v":68},{"$f":"IF(C4=\"Well\", E4*Inputs!$I$82, E4*Inputs!$G$82)","v":68}]
[null,"Drilling Fluid and Materials","Well",79,80,{"$f":"IF(C5=\"Well\", E5*Inputs!$I$82, E5*Inputs!$G$82)","v":640}]
[null,"Drilling Equipment","Well",65,{"$f":"ROUNDDOWN(D6/2, 0)*2","v":64},{"$f":"IF(C6=\"Well\", E6*Inputs!$I$82, E6*Inputs!$G$82)","v":512}]
["Completion","Completion Rig","Pad",33,{"$f":"ROUNDDOWN(D7/2, 0)*2","v":32},{"$f":"IF(C7=\"Well\", E7*Inputs!$I$82, E7*Inputs!$G$82)","v":32}]
[null,"Completion Fluid and Materials","Well",32,32,{"$f":"IF(C8=\"Well\", E8*Inputs!$I$82, E8*Inputs!$G$82)","v":256}]
[null,"Completion Equipment","Pad",13,{"$f":"ROUNDDOWN(D9/2, 0)*2","v":12},{"$f":"IF(C9=\"Well\", E9*Inputs!$I$82, E9*Inputs!$G$82)","v":12}]
[null,"Fracturing Equipment","Pad",250,250,{"$f":"IF(C10=\"Well\", E10*Inputs!$I$82, E10*Inputs!$G$82)","v":250}]
[null,"Fracture Water","Well",923,{"$f":"ROUNDDOWN(D11/2, 0)*2","v":922},{"$f":"IF(C11=\"Well\", E11*Inputs!$I$82, E11*Inputs!$G$82)","v":7376}]
[null,"Fracture Sand","Well",84,84,{"$f":"IF(C12=\"Well\", E12*Inputs!$I$82, E12*Inputs!$G$82)","v":672}]
[null,"Flowback Water Disposal","Well",308,308,{"$f":"IF(C13=\"Well\", E13*Inputs!$I$82, E13*Inputs!$G$82)","v":2464}]
["Total:",null,null,{"$f":"SUM(D3:D13)","v":1941},{"$f":"SUM(E3:E13)","v":1940},{"$f":"SUM(F3:F13)","v":12370}]
["Vertical"]
["Stage","Phase","Pad/Well","Raw Trips","Rounded Trips","Total Trips"]
["Construction","Pad and Road Construction","Pad",63,{"$f":"ROUND(D17/2, 0)*2","v":64},{"$f":"IF(C17=\"Well\", E17*Inputs!$I$82, E17*Inputs!$G$82)","v":64}]
["Drilling","Drilling Rig","Pad",66,{"$f":"ROUND(D18/2, 0)*2","v":66},{"$f":"IF(C18=\"Well\", E18*Inputs!$I$82, E18*Inputs!$G$82)","v":66}]
[null,"Drilling Fluid and Materials","Well",45,{"$f":"ROUNDDOWN(D19/2, 0)*2","v":44},{"$f":"IF(C19=\"Well\", E19*Inputs!$I$82, E19*Inputs!$G$82)","v":352}]
[null,"Drilling Equipment","Well",59,{"$f":"ROUND(D20/2, 0)*2","v":60},{"$f":"IF(C20=\"Well\", E20*Inputs!$I$82, E20*Inputs!$G$82)","v":480}]
["Completion","Completion Rig","Pad",22,{"$f":"ROUND(D21/2, 0)*2","v":22},{"$f":"IF(C21=\"Well\", E21*Inputs!$I$82, E21*Inputs!$G$82)","v":22}]
[null,"Completion Fluid and Materials","Well",24,{"$f":"ROUND(D22/2, 0)*2","v":24},{"$f":"IF(C22=\"Well\", E22*Inputs!$I$82, E22*Inputs!$G$82)","v":192}]
[null,"Completion Equipment","Pad",8,{"$f":"ROUND(D23/2, 0)*2","v":8},{"$f":"IF(C23=\"Well\", E23*Inputs!$I$82, E23*Inputs!$G$82)","v":8}]
[null,"Fracturing Equipment","Pad",147,{"$f":"ROUNDDOWN(D24/2, 0)*2","v":146},{"$f":"IF(C24=\"Well\", E24*Inputs!$I$82, E24*Inputs!$G$82)","v":146}]
[null,"Fracture Water","Well",246,{"$f":"ROUND(D25/2, 0)*2","v":246},{"$f":"IF(C25=\"Well\", E25*Inputs!$I$82, E25*Inputs!$G$82)","v":1968}]
[null,"Fracture Sand","Well",15,{"$f":"ROUND(D26/2, 0)*2","v":16},{"$f":"IF(C26=\"Well\", E26*Inputs!$I$82, E26*Inputs!$G$82)","v":128}]
[null,"Flowback Water Disposal","Well",103,{"$f":"ROUNDDOWN(D27/2, 0)*2","v":102},{"$f":"IF(C27=\"Well\", E27*Inputs!$I$82, E27*Inputs!$G$82)","v":816}]
["Total:",null,null,{"$f":"SUM(D17:D27)","v":798},{"$f":"SUM(E17:E27)","v":798},{"$f":"SUM(F17:F27)","v":4242}]
["Vertical Recompletion"]
["Stage","Phase","Pad/Well","Raw Trips","Rounded Trips","Total Trips"]
["Completion","Completion Rig","Pad",22,{"$f":"ROUND(D31/2, 0)*2","v":22},{"$f":"IF(C31=\"Well\", E31*Inputs!$I$82, E31*Inputs!$G$82)","v":22}]
[null,"Completion Fluid and Materials","Well",24,{"$f":"ROUND(D32/2, 0)*2","v":24},{"$f":"IF(C32=\"Well\", E32*Inputs!$I$82, E32*Inputs!$G$82)","v":192}]
[null,"Completion Equipment","Pad",8,{"$f":"ROUND(D33/2, 0)*2","v":8},{"$f":"IF(C33=\"Well\", E33*Inputs!$I$82, E33*Inputs!$G$82)","v":8}]
[null,"Fracturing Equipment","Pad",147,{"$f":"ROUNDDOWN(D34/2, 0)*2","v":146},{"$f":"IF(C34=\"Well\", E34*Inputs!$I$82, E34*Inputs!$G$82)","v":146}]
[null,"Fracture Water","Well",246,{"$f":"ROUND(D35/2, 0)*2","v":246},{"$f":"IF(C35=\"Well\", E35*Inputs!$I$82, E35*Inputs!$G$82)","v":1968}]
[null,"Fracture Sand","Well",15,{"$f":"ROUND(D36/2, 0)*2","v":16},{"$f":"IF(C36=\"Well\", E36*Inputs!$I$82, E36*Inputs!$G$82)","v":128}]
[null,"Flowback Water Disposal","Well",103,{"$f":"ROUNDDOWN(D37/2, 0)*2","v":102},{"$f":"IF(C37=\"Well\", E37*Inputs!$I$82, E37*Inputs!$G$82)","v":816}]
["Total:",null,null,{"$f":"SUM(D31:D37)","v":565},{"$f":"SUM(E31:E37)","v":564},{"$f":"SUM(F31:F37)","v":3280}]
["Production"]
["Production","Production (Future Pads)","Pad",560,560,{"$f":"IF(C40=\"Well\", E40*Inputs!$I$82, E40*Inputs!$G$82)","v":560}]
[null,"Production (Existing Pads)","Pad",560,560,{"$f":"IF(C41=\"Well\", E41*Inputs!$I$92, E41*Inputs!$G$92)","v":0}]
[]
["*from BBC Consulting, as of 11/5/2014"]

{"sheet":"TruckImpacts","index":4,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":true,"merged":[[1,0,1,6],[7,0,7,6],[40,0,40,6],[60,0,60,6]]}
["Truck ID","Group ID","Name","Empty/Full","Dev Type","Flexible","Rigid"]
["Pad Construction"]
["PC1E","EQUIP","Construction Equipment Truck - EMPTY","Empty","Both",8.7999999999999995E-2,9.0999999999999998E-2]
["PC1F","EQUIP","Construction Equipment Truck - LOADED","Full","Both",1.0209999999999999,1.663]
["PC2E","GRAV","Gravel Truck - EMPTY","Empty","Both",0.10199999999999999,0.105]
["PC2F","GRAV","Gravel Truck - LOADED","Full","Both",1.5649999999999999,2.63]
["PC3","WORK","Pickup Truck","Full","Both",3.0000000000000001E-3,3.0000000000000001E-3]
["Development"]
["D1","RIG","Generator House","Full","Both",3.8719999999999999,9.343]
["D2","RIG","Crown Section","Full","Both",8.2460000000000004,15.929]
["D3","RIG","Shaker Tank/Pit","Full","Both",2.5569999999999999,6.0830000000000002]
["D4","RIG","Derrick","Full","Both",8.4770000000000003,18.481000000000002]
["D5","RIG","Suction Tank","Full","Both",2.7730000000000001,5.42]
["D6","RIG","VFD House","Full","Both",3.6669999999999998,8.0370000000000008]
["D7","RIG","Mud Pump","Full","Both",5.5039999999999996,12.781000000000001]
["D8","RIG","Mud Boat","Full","Both",5.2110000000000003,11.345000000000001]
["D9","RIG","Shaker Skid","Full","Both",5.2149999999999999,11.382999999999999]
["D10","RIG","Substructure, etc.","Full","Both",9.0129999999999999,14.914999999999999]
["D11","RIG","Draw Works","Full","Both",6.3250000000000002,15.047000000000001]
["D12","RIG","Hydraulic Unit","Full","Both",3.9889999999999999,8.8350000000000009]
["D13","RIG","Choke Manifold","Full","Both",6.2640000000000002,10.436]
["D14","RIG","MCC House","Full","Both",7.4290000000000003,16.707999999999998]
["D15","RIG","Tool Room / Junk Box","Full","Both",5.9649999999999999,13.566000000000001]
["D16","RIG","Screen House","Full","Both",2.6230000000000002,6.3339999999999996]
["D17","RIG","Light Plant","Full","Both",3.34,8.6579999999999995]
["D18","RIG","Mud Tank","Full","Both",3.4580000000000002,6.7770000000000001]
["D19E","CEM","Cement Truck - EMPTY","Empty","Both",0.28299999999999997,0.26700000000000002]
["D19F","CEM","Cement Truck - LOADED","Full","Both",2.3439999999999999,3.5649999999999999]
["D20","CEM","Cement Pump","Full","Both",1.52,2.6659999999999999]
["D21","CHEM","Acid Pump","Full","Horizontal",2.323,4.0540000000000003]
["D22E","CHEM","Acid Tanker - EMPTY","Empty","Horizontal",0.109,0.111]
["D22F","CHEM","Acid Tanker - LOADED","Full","Horizontal",3.113,5.5670000000000002]
["D23E","PIPE","Pipe - EMPTY","Empty","Both",8.7999999999999995E-2,9.0999999999999998E-2]
["D23F","PIPE","Pipe - LOADED","Full","Both",2.4430000000000001,4.2809999999999997]
["D24E","FUEL","Fuel Truck - EMPTY","Empty","Both",0.28299999999999997,0.26700000000000002]
["D24F","FUEL","Fuel Truck - LOADED","Full","Both",2.3439999999999999,3.5649999999999999]
["D25E","F-WATER","Water - EMPTY","Empty","Both",7.4999999999999997E-2,7.8E-2]
["D25F1","F-WATER","Fresh Water - LOADED","Full","Both",1.42,2.403]
["D25F2","P-WATER","Produced Water - LOADED","Full","Both",3.113,5.5670000000000002]
["D26","WORK","Pickup Truck","Full","Both",3.0000000000000001E-3,3.0000000000000001E-3]
["Completion"]
["C1","RIG","Workover Rig","Full","Both",5.7759999999999998,13.391999999999999]
["C2E","F-WATER","Water - EMPTY","Empty","Horizontal",7.4999999999999997E-2,7.8E-2]
["C2F1","F-WATER","Fresh Water - LOADED","Full","Horizontal",1.42,2.403]
["C2F2","P-WATER","Produced Water - LOADED","Full","Horizontal",3.113,5.5670000000000002]
["C3E","SAND","Sand Truck - EMPTY","Empty","Horizontal",0.105,0.17100000000000001]
["C3F","SAND","Sand Truck - LOADED","Full","Horizontal",2.5470000000000002,4.5369999999999999]
["C4E","PIPE","Pipe - EMPTY","Empty","Both",8.7999999999999995E-2,9.0999999999999998E-2]
["C4F","PIPE","Pipe - LOADED","Full","Both",2.4430000000000001,4.2809999999999997]
["C5","RIG","Wireline","Full","Both",2.3439999999999999,3.5649999999999999]
["C6E","CHEM","Chemical Truck - EMPTY","Empty","Both",0.28299999999999997,0.26700000000000002]
["C6F","CHEM","Chemical Truck - LOADED","Full","Both",2.3439999999999999,3.5649999999999999]
["C7E","RIG","Frac Tank - EMPTY","Empty","Horizontal",8.8999999999999996E-2,8.4000000000000005E-2]
["C7F","RIG","Frac Tank - LOADED","Full","Horizontal",9.7000000000000003E-2,9.5000000000000001E-2]
["C8","F-WATER","Pump Truck","Full","Both",1.4330000000000001,2.6110000000000002]
["C9","RIG","Control Van","Full","Both",0.442,0.624]
["C10E","FUEL","Fuel Truck - EMPTY","Empty","Both",0.28299999999999997,0.26700000000000002]
["C10F","FUEL","Fuel Truck - LOADED","Full","Both",2.3439999999999999,3.5649999999999999]
["C11","WORK","Pickup Truck","Full","Both",3.0000000000000001E-3,3.0000000000000001E-3]
["C12","CHEM","Acid Pump","Full","Horizontal",2.323,4.0540000000000003]
["Production"]
["P1F","OIL","Oil - LOADED","Full","Both",2.4430000000000001,4.2809999999999997]
["P1E","OIL","Oil - Empty","Empty","Both",0.75,0.78]
["P2E","F-WATER","Water - EMPTY","Empty","Horizontal",0.75,0.78]
["P2F","P-WATER","Produced Water - LOADED","Full","Horizontal",3.113,5.5670000000000002]
["P3","WORK","Pickup Truck","Full","Both",3.0000000000000001E-3,3.0000000000000001E-3]

{"sheet":"TruckDistribution","index":5,"n_rows":163,"n_cols":14,"rows_kept":163,"cut":false,"hidden":true,"merged":[[160,11,160,13],[137,0,156,0],[137,1,138,1],[137,2,138,2],[139,1,142,1],[139,2,142,2],[143,1,146,1],[143,2,146,2],[147,1,150,1],[147,2,150,2],[151,1,152,1],[151,2,152,2],[153,1,154,1],[153,2,154,2],[155,1,156,1],[155,2,156,2],[114,0,133,0],[114,1,115,1],[114,2,115,2],[116,1,119,1],[116,2,119,2],[120,1,123,1],[120,2,123,2],[124,1,127,1],[124,2,127,2],[128,1,129,1],[128,2,129,2],[130,1,131,1],[130,2,131,2],[132,1,133,1],[132,2,133,2],[77,0,81,0],[77,1,81,1],[77,2,81,2],[82,0,113,0],[82,1,100,1],[82,2,100,2],[101,1,107,1],[101,2,107,2],[108,1,113,1],[108,2,113,2],[69,0,73,0],[69,2,73,2],[70,1,71,1],[72,1,73,1],[6,0,37,0],[38,2,39,2],[40,1,43,1],[40,2,43,2],[25,2,31,2],[25,1,31,1],[32,2,37,2],[32,1,37,1],[61,0,65,0],[62,1,63,1],[64,1,65,1],[61,2,65,2],[1,2,5,2],[1,1,5,1],[1,0,5,0],[6,2,24,2],[6,1,24,1],[54,1,55,1],[54,2,55,2],[56,2,57,2],[56,1,57,1],[38,0,57,0],[44,2,47,2],[44,1,47,1],[48,2,51,2],[48,1,51,1],[52,2,53,2],[52,1,53,1],[38,1,39,1]]}
["Stage","Phase","Trips","Truck ID","Group ID","Truck Name","Dir","Base","% Phase","Overall","% Rd","Mod","Flexible ESALs","Rigid ESALs"]
["Construction (Horizontal)","Pad and Road Construction",{"$f":"TripGen!F3","v":88},{"$f":"TruckImpacts!A$3","v":"PC1E"},{"$f":"TruckImpacts!B$3","v":"EQUIP"},{"$f":"TruckImpacts!C$3","v":"Construction Equipment Truck - EMPTY"},"Both",8,9.0909090909090912E-2,{"$f":"I2*C$2","v":8},{"$f":"SUMIF(Inputs!$A$99:$A$109, E2, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J2*K2, 0)","v":8},{"$f":"SUMIF(TruckImpacts!$A:$A, $D2, TruckImpacts!F:F)*$L2","v":0.70399999999999996},{"$f":"SUMIF(TruckImpacts!$A:$A, $D2, TruckImpacts!G:G)*$L2","v":0.72799999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$4","v":"PC1F"},{"$f":"TruckImpacts!B$4","v":"EQUIP"},{"$f":"TruckImpacts!C$4","v":"Construction Equipment Truck - LOADED"},"Both",8,9.0909090909090912E-2,{"$f":"I3*C$2","v":8},{"$f":"SUMIF(Inputs!$A$99:$A$109, E3, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J3*K3, 0)","v":8},{"$f":"SUMIF(TruckImpacts!$A:$A, $D3, TruckImpacts!F:F)*$L3","v":8.1679999999999993},{"$f":"SUMIF(TruckImpacts!$A:$A, $D3, TruckImpacts!G:G)*$L3","v":13.304}]
[null,null,null,{"$f":"TruckImpacts!A$5","v":"PC2E"},{"$f":"TruckImpacts!B$5","v":"GRAV"},{"$f":"TruckImpacts!C$5","v":"Gravel Truck - EMPTY"},"Out",20,0.22727272727272727,20,{"$f":"SUMIF(Inputs!$A$99:$A$109, E4, Inputs!$G$99:$G$109)/100","v":1},20,{"$f":"SUMIF(TruckImpacts!$A:$A, $D4, TruckImpacts!F:F)*$L4","v":2.04},{"$f":"SUMIF(TruckImpacts!$A:$A, $D4, TruckImpacts!G:G)*$L4","v":2.1}]
[null,null,null,{"$f":"TruckImpacts!A$6","v":"PC2F"},{"$f":"TruckImpacts!B$6","v":"GRAV"},{"$f":"TruckImpacts!C$6","v":"Gravel Truck - LOADED"},"In",20,0.22727272727272727,20,{"$f":"SUMIF(Inputs!$A$99:$A$109, E5, Inputs!$G$99:$G$109)/100","v":1},20,{"$f":"SUMIF(TruckImpacts!$A:$A, $D5, TruckImpacts!F:F)*$L5","v":31.299999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D5, TruckImpacts!G:G)*$L5","v":52.599999999999994}]
[null,null,null,{"$f":"TruckImpacts!A$7","v":"PC3"},{"$f":"TruckImpacts!B$7","v":"WORK"},{"$f":"TruckImpacts!C$7","v":"Pickup Truck"},"Both",32,0.36363636363636365,32,{"$f":"SUMIF(Inputs!$A$99:$A$109, E6, Inputs!$G$99:$G$109)/100","v":1},32,{"$f":"SUMIF(TruckImpacts!$A:$A, $D6, TruckImpacts!F:F)*$L6","v":9.6000000000000002E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D6, TruckImpacts!G:G)*$L6","v":9.6000000000000002E-2}]
["Drilling (Horizontal)","Drilling Rig",{"$f":"TripGen!F4","v":68},{"$f":"TruckImpacts!A$9","v":"D1"},{"$f":"TruckImpacts!B$9","v":"RIG"},{"$f":"TruckImpacts!C$9","v":"Generator House"},"Both",6,8.8235294117647065E-2,{"$f":"I7*C$7","v":6},{"$f":"SUMIF(Inputs!$A$99:$A$109, E7, Inputs!$G$99:$G$109)/100","v":1},6,{"$f":"SUMIF(TruckImpacts!$A:$A, $D7, TruckImpacts!F:F)*$L7","v":23.231999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D7, TruckImpacts!G:G)*$L7","v":56.058}]
[null,null,null,{"$f":"TruckImpacts!A$10","v":"D2"},{"$f":"TruckImpacts!B$10","v":"RIG"},{"$f":"TruckImpacts!C$10","v":"Crown Section"},"Both",2,2.9411764705882353E-2,{"$f":"I8*C$7","v":2},{"$f":"SUMIF(Inputs!$A$99:$A$109, E8, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D8, TruckImpacts!F:F)*$L8","v":16.492000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D8, TruckImpacts!G:G)*$L8","v":31.858000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$11","v":"D3"},{"$f":"TruckImpacts!B$11","v":"RIG"},{"$f":"TruckImpacts!C$11","v":"Shaker Tank/Pit"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E9, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D9, TruckImpacts!F:F)*$L9","v":5.1139999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D9, TruckImpacts!G:G)*$L9","v":12.166}]
[null,null,null,{"$f":"TruckImpacts!A$12","v":"D4"},{"$f":"TruckImpacts!B$12","v":"RIG"},{"$f":"TruckImpacts!C$12","v":"Derrick"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E10, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D10, TruckImpacts!F:F)*$L10","v":16.954000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D10, TruckImpacts!G:G)*$L10","v":36.962000000000003}]
[null,null,null,{"$f":"TruckImpacts!A$13","v":"D5"},{"$f":"TruckImpacts!B$13","v":"RIG"},{"$f":"TruckImpacts!C$13","v":"Suction Tank"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E11, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D11, TruckImpacts!F:F)*$L11","v":5.5460000000000003},{"$f":"SUMIF(TruckImpacts!$A:$A, $D11, TruckImpacts!G:G)*$L11","v":10.84}]
[null,null,null,{"$f":"TruckImpacts!A$14","v":"D6"},{"$f":"TruckImpacts!B$14","v":"RIG"},{"$f":"TruckImpacts!C$14","v":"VFD House"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E12, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D12, TruckImpacts!F:F)*$L12","v":7.3339999999999996},{"$f":"SUMIF(TruckImpacts!$A:$A, $D12, TruckImpacts!G:G)*$L12","v":16.074000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$15","v":"D7"},{"$f":"TruckImpacts!B$15","v":"RIG"},{"$f":"TruckImpacts!C$15","v":"Mud Pump"},"Both",4,5.8823529411764705E-2,4,{"$f":"SUMIF(Inputs!$A$99:$A$109, E13, Inputs!$G$99:$G$109)/100","v":1},4,{"$f":"SUMIF(TruckImpacts!$A:$A, $D13, TruckImpacts!F:F)*$L13","v":22.015999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D13, TruckImpacts!G:G)*$L13","v":51.124000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$16","v":"D8"},{"$f":"TruckImpacts!B$16","v":"RIG"},{"$f":"TruckImpacts!C$16","v":"Mud Boat"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E14, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D14, TruckImpacts!F:F)*$L14","v":10.422000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D14, TruckImpacts!G:G)*$L14","v":22.69}]
[null,null,null,{"$f":"TruckImpacts!A$17","v":"D9"},{"$f":"TruckImpacts!B$17","v":"RIG"},{"$f":"TruckImpacts!C$17","v":"Shaker Skid"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E15, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D15, TruckImpacts!F:F)*$L15","v":10.43},{"$f":"SUMIF(TruckImpacts!$A:$A, $D15, TruckImpacts!G:G)*$L15","v":22.765999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$18","v":"D10"},{"$f":"TruckImpacts!B$18","v":"RIG"},{"$f":"TruckImpacts!C$18","v":"Substructure, etc."},"Both",10,0.14705882352941177,10,{"$f":"SUMIF(Inputs!$A$99:$A$109, E16, Inputs!$G$99:$G$109)/100","v":1},10,{"$f":"SUMIF(TruckImpacts!$A:$A, $D16, TruckImpacts!F:F)*$L16","v":90.13},{"$f":"SUMIF(TruckImpacts!$A:$A, $D16, TruckImpacts!G:G)*$L16","v":149.14999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$19","v":"D11"},{"$f":"TruckImpacts!B$19","v":"RIG"},{"$f":"TruckImpacts!C$19","v":"Draw Works"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E17, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D17, TruckImpacts!F:F)*$L17","v":12.65},{"$f":"SUMIF(TruckImpacts!$A:$A, $D17, TruckImpacts!G:G)*$L17","v":30.094000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$20","v":"D12"},{"$f":"TruckImpacts!B$20","v":"RIG"},{"$f":"TruckImpacts!C$20","v":"Hydraulic Unit"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E18, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D18, TruckImpacts!F:F)*$L18","v":7.9779999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D18, TruckImpacts!G:G)*$L18","v":17.670000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$21","v":"D13"},{"$f":"TruckImpacts!B$21","v":"RIG"},{"$f":"TruckImpacts!C$21","v":"Choke Manifold"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E19, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D19, TruckImpacts!F:F)*$L19","v":12.528},{"$f":"SUMIF(TruckImpacts!$A:$A, $D19, TruckImpacts!G:G)*$L19","v":20.872}]
[null,null,null,{"$f":"TruckImpacts!A$22","v":"D14"},{"$f":"TruckImpacts!B$22","v":"RIG"},{"$f":"TruckImpacts!C$22","v":"MCC House"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E20, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D20, TruckImpacts!F:F)*$L20","v":14.858000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D20, TruckImpacts!G:G)*$L20","v":33.415999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$23","v":"D15"},{"$f":"TruckImpacts!B$23","v":"RIG"},{"$f":"TruckImpacts!C$23","v":"Tool Room / Junk Box"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E21, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D21, TruckImpacts!F:F)*$L21","v":11.93},{"$f":"SUMIF(TruckImpacts!$A:$A, $D21, TruckImpacts!G:G)*$L21","v":27.132000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$24","v":"D16"},{"$f":"TruckImpacts!B$24","v":"RIG"},{"$f":"TruckImpacts!C$24","v":"Screen House"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E22, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D22, TruckImpacts!F:F)*$L22","v":5.2460000000000004},{"$f":"SUMIF(TruckImpacts!$A:$A, $D22, TruckImpacts!G:G)*$L22","v":12.667999999999999}]
[null,null,null,{"$f":"TruckImpacts!A$25","v":"D17"},{"$f":"TruckImpacts!B$25","v":"RIG"},{"$f":"TruckImpacts!C$25","v":"Light Plant"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E23, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D23, TruckImpacts!F:F)*$L23","v":6.68},{"$f":"SUMIF(TruckImpacts!$A:$A, $D23, TruckImpacts!G:G)*$L23","v":17.315999999999999}]
[null,null,null,{"$f":"TruckImpacts!A$26","v":"D18"},{"$f":"TruckImpacts!B$26","v":"RIG"},{"$f":"TruckImpacts!C$26","v":"Mud Tank"},"Both",2,2.9411764705882353E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E24, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D24, TruckImpacts!F:F)*$L24","v":6.9160000000000004},{"$f":"SUMIF(TruckImpacts!$A:$A, $D24, TruckImpacts!G:G)*$L24","v":13.554}]
[null,null,null,{"$f":"TruckImpacts!A$40","v":"D26"},{"$f":"TruckImpacts!B$40","v":"WORK"},{"$f":"TruckImpacts!C$40","v":"Pickup Truck"},"Both",18,0.26470588235294118,18,{"$f":"SUMIF(Inputs!$A$99:$A$109, E25, Inputs!$G$99:$G$109)/100","v":1},18,{"$f":"SUMIF(TruckImpacts!$A:$A, $D25, TruckImpacts!F:F)*$L25","v":5.3999999999999999E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D25, TruckImpacts!G:G)*$L25","v":5.3999999999999999E-2}]
[null,"Drilling Fluid and Materials",{"$f":"TripGen!F5","v":640},{"$f":"TruckImpacts!A$27","v":"D19E"},{"$f":"TruckImpacts!B$27","v":"CEM"},{"$f":"TruckImpacts!C$27","v":"Cement Truck - EMPTY"},"Out",9,0.1125,{"$f":"I26*C$26","v":72},{"$f":"SUMIF(Inputs!$A$99:$A$109, E26, Inputs!$G$99:$G$109)/100","v":1},72,{"$f":"SUMIF(TruckImpacts!$A:$A, $D26, TruckImpacts!F:F)*$L26","v":20.375999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D26, TruckImpacts!G:G)*$L26","v":19.224}]
[null,null,null,{"$f":"TruckImpacts!A$28","v":"D19F"},{"$f":"TruckImpacts!B$28","v":"CEM"},{"$f":"TruckImpacts!C$28","v":"Cement Truck - LOADED"},"In",9,0.1125,{"$f":"I27*C$26","v":72},{"$f":"SUMIF(Inputs!$A$99:$A$109, E27, Inputs!$G$99:$G$109)/100","v":1},72,{"$f":"SUMIF(TruckImpacts!$A:$A, $D27, TruckImpacts!F:F)*$L27","v":168.768},{"$f":"SUMIF(TruckImpacts!$A:$A, $D27, TruckImpacts!G:G)*$L27","v":256.68}]
[null,null,null,{"$f":"TruckImpacts!A$31","v":"D22E"},{"$f":"TruckImpacts!B$31","v":"CHEM"},{"$f":"TruckImpacts!C$31","v":"Acid Tanker - EMPTY"},"Out",5,6.25E-2,40,{"$f":"SUMIF(Inputs!$A$99:$A$109, E28, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D28, TruckImpacts!F:F)*$L28","v":4.3600000000000003},{"$f":"SUMIF(TruckImpacts!$A:$A, $D28, TruckImpacts!G:G)*$L28","v":4.4400000000000004}]
[null,null,null,{"$f":"TruckImpacts!A$32","v":"D22F"},{"$f":"TruckImpacts!B$32","v":"CHEM"},{"$f":"TruckImpacts!C$32","v":"Acid Tanker - LOADED"},"In",5,6.25E-2,40,{"$f":"SUMIF(Inputs!$A$99:$A$109, E29, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D29, TruckImpacts!F:F)*$L29","v":124.52},{"$f":"SUMIF(TruckImpacts!$A:$A, $D29, TruckImpacts!G:G)*$L29","v":222.68}]
[null,null,null,{"$f":"TruckImpacts!A$37","v":"D25E"},{"$f":"TruckImpacts!B$37","v":"F-WATER"},{"$f":"TruckImpacts!C$37","v":"Water - EMPTY"},"Both",{"$f":"SUM(H31:H32)","v":26},{"$f":"SUM(I31:I32)","v":0.32500000000000001},{"$f":"SUM(J31:J32)","v":208},null,{"$f":"SUM(L31:L32)","v":208},{"$f":"SUMIF(TruckImpacts!$A:$A, $D30, TruckImpacts!F:F)*$L30","v":15.6},{"$f":"SUMIF(TruckImpacts!$A:$A, $D30, TruckImpacts!G:G)*$L30","v":16.224}]
[null,null,null,{"$f":"TruckImpacts!A$38","v":"D25F1"},{"$f":"TruckImpacts!B$38","v":"F-WATER"},{"$f":"TruckImpacts!C$38","v":"Fresh Water - LOADED"},"In",13,0.16250000000000001,104,{"$f":"(SUMIF(Inputs!$A$99:$A$109, E31, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},104,{"$f":"SUMIF(TruckImpacts!$A:$A, $D31, TruckImpacts!F:F)*$L31","v":147.68},{"$f":"SUMIF(TruckImpacts!$A:$A, $D31, TruckImpacts!G:G)*$L31","v":249.91200000000001}]
[null,null,null,{"$f":"TruckImpacts!A$39","v":"D25F2"},{"$f":"TruckImpacts!B$39","v":"P-WATER"},{"$f":"TruckImpacts!C$39","v":"Produced Water - LOADED"},"Out",13,0.16250000000000001,104,{"$f":"SUMIF(Inputs!$A$99:$A$109, E32, Inputs!$G$99:$G$109)/100","v":1},104,{"$f":"SUMIF(TruckImpacts!$A:$A, $D32, TruckImpacts!F:F)*$L32","v":323.75200000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D32, TruckImpacts!G:G)*$L32","v":578.96800000000007}]
[null,"Drilling Equipment",{"$f":"TripGen!F6","v":512},{"$f":"TruckImpacts!A$29","v":"D20"},{"$f":"TruckImpacts!B$29","v":"CEM"},{"$f":"TruckImpacts!C$29","v":"Cement Pump"},"Both",14,0.21875,{"$f":"I33*C$33","v":112},{"$f":"SUMIF(Inputs!$A$99:$A$109, E33, Inputs!$G$99:$G$109)/100","v":1},112,{"$f":"SUMIF(TruckImpacts!$A:$A, $D33, TruckImpacts!F:F)*$L33","v":170.24},{"$f":"SUMIF(TruckImpacts!$A:$A, $D33, TruckImpacts!G:G)*$L33","v":298.59199999999998}]
[null,null,null,{"$f":"TruckImpacts!A$30","v":"D21"},{"$f":"TruckImpacts!B$30","v":"CHEM"},{"$f":"TruckImpacts!C$30","v":"Acid Pump"},"Both",4,6.25E-2,{"$f":"I34*C$33","v":32},{"$f":"SUMIF(Inputs!$A$99:$A$109, E34, Inputs!$G$99:$G$109)/100","v":1},32,{"$f":"SUMIF(TruckImpacts!$A:$A, $D34, TruckImpacts!F:F)*$L34","v":74.335999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D34, TruckImpacts!G:G)*$L34","v":129.72800000000001}]
[null,null,null,{"$f":"TruckImpacts!A$35","v":"D24E"},{"$f":"TruckImpacts!B$35","v":"FUEL"},{"$f":"TruckImpacts!C$35","v":"Fuel Truck - EMPTY"},"Out",8,0.125,64,{"$f":"SUMIF(Inputs!$A$99:$A$109, E35, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D35, TruckImpacts!F:F)*$L35","v":18.111999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D35, TruckImpacts!G:G)*$L35","v":17.088000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$36","v":"D24F"},{"$f":"TruckImpacts!B$36","v":"FUEL"},{"$f":"TruckImpacts!C$36","v":"Fuel Truck - LOADED"},"In",8,0.125,64,{"$f":"SUMIF(Inputs!$A$99:$A$109, E36, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D36, TruckImpacts!F:F)*$L36","v":150.01599999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D36, TruckImpacts!G:G)*$L36","v":228.16}]
[null,null,null,{"$f":"TruckImpacts!A$33","v":"D23E"},{"$f":"TruckImpacts!B$33","v":"PIPE"},{"$f":"TruckImpacts!C$33","v":"Pipe - EMPTY"},"Out",15,0.234375,120,{"$f":"SUMIF(Inputs!$A$99:$A$109, E37, Inputs!$G$99:$G$109)/100","v":1},120,{"$f":"SUMIF(TruckImpacts!$A:$A, $D37, TruckImpacts!F:F)*$L37","v":10.559999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D37, TruckImpacts!G:G)*$L37","v":10.92}]
[null,null,null,{"$f":"TruckImpacts!A$34","v":"D23F"},{"$f":"TruckImpacts!B$34","v":"PIPE"},{"$f":"TruckImpacts!C$34","v":"Pipe - LOADED"},"In",15,0.234375,120,{"$f":"SUMIF(Inputs!$A$99:$A$109, E38, Inputs!$G$99:$G$109)/100","v":1},120,{"$f":"SUMIF(TruckImpacts!$A:$A, $D38, TruckImpacts!F:F)*$L38","v":293.16000000000003},{"$f":"SUMIF(TruckImpacts!$A:$A, $D38, TruckImpacts!G:G)*$L38","v":513.71999999999991}]
["Completion (Horizontal)","Completion Rig",{"$f":"TripGen!F7","v":32},{"$f":"TruckImpacts!A$42","v":"C1"},{"$f":"TruckImpacts!B$42","v":"RIG"},{"$f":"TruckImpacts!C$42","v":"Workover Rig"},"Both",6,0.1875,{"$f":"I39*C39","v":6},{"$f":"SUMIF(Inputs!$A$99:$A$109, E39, Inputs!$G$99:$G$109)/100","v":1},6,{"$f":"SUMIF(TruckImpacts!$A:$A, $D39, TruckImpacts!F:F)*$L39","v":34.655999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D39, TruckImpacts!G:G)*$L39","v":80.352000000000004}]
[null,null,null,{"$f":"TruckImpacts!A$59","v":"C11"},{"$f":"TruckImpacts!B$59","v":"WORK"},{"$f":"TruckImpacts!C$59","v":"Pickup Truck"},"Both",26,0.8125,{"$f":"I40*C39","v":26},{"$f":"SUMIF(Inputs!$A$99:$A$109, E40, Inputs!$G$99:$G$109)/100","v":1},26,{"$f":"SUMIF(TruckImpacts!$A:$A, $D40, TruckImpacts!F:F)*$L40","v":7.8E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D40, TruckImpacts!G:G)*$L40","v":7.8E-2}]
[null,"Completion Fluid and Materials",{"$f":"TripGen!F8","v":256},{"$f":"TruckImpacts!A$51","v":"C6E"},{"$f":"TruckImpacts!B$51","v":"CHEM"},{"$f":"TruckImpacts!C$51","v":"Chemical Truck - EMPTY"},"Out",10,0.3125,{"$f":"I41*C$41","v":80},{"$f":"SUMIF(Inputs!$A$99:$A$109, E41, Inputs!$G$99:$G$109)/100","v":1},80,{"$f":"SUMIF(TruckImpacts!$A:$A, $D41, TruckImpacts!F:F)*$L41","v":22.639999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D41, TruckImpacts!G:G)*$L41","v":21.36}]
[null,null,null,{"$f":"TruckImpacts!A$52","v":"C6F"},{"$f":"TruckImpacts!B$52","v":"CHEM"},{"$f":"TruckImpacts!C$52","v":"Chemical Truck - LOADED"},"In",10,0.3125,{"$f":"I42*C$41","v":80},{"$f":"SUMIF(Inputs!$A$99:$A$109, E42, Inputs!$G$99:$G$109)/100","v":1},80,{"$f":"SUMIF(TruckImpacts!$A:$A, $D42, TruckImpacts!F:F)*$L42","v":187.51999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D42, TruckImpacts!G:G)*$L42","v":285.2}]
[null,null,null,{"$f":"TruckImpacts!A$57","v":"C10E"},{"$f":"TruckImpacts!B$57","v":"FUEL"},{"$f":"TruckImpacts!C$57","v":"Fuel Truck - EMPTY"},"Out",6,0.1875,48,{"$f":"SUMIF(Inputs!$A$99:$A$109, E43, Inputs!$G$99:$G$109)/100","v":1},48,{"$f":"SUMIF(TruckImpacts!$A:$A, $D43, TruckImpacts!F:F)*$L43","v":13.584},{"$f":"SUMIF(TruckImpacts!$A:$A, $D43, TruckImpacts!G:G)*$L43","v":12.816000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$58","v":"C10F"},{"$f":"TruckImpacts!B$58","v":"FUEL"},{"$f":"TruckImpacts!C$58","v":"Fuel Truck - LOADED"},"In",6,0.1875,48,{"$f":"SUMIF(Inputs!$A$99:$A$109, E44, Inputs!$G$99:$G$109)/100","v":1},48,{"$f":"SUMIF(TruckImpacts!$A:$A, $D44, TruckImpacts!F:F)*$L44","v":112.512},{"$f":"SUMIF(TruckImpacts!$A:$A, $D44, TruckImpacts!G:G)*$L44","v":171.12}]
[null,"Completion Equipment",{"$f":"TripGen!F9","v":12},{"$f":"TruckImpacts!A$48","v":"C4E"},{"$f":"TruckImpacts!B$48","v":"PIPE"},{"$f":"TruckImpacts!C$48","v":"Pipe - EMPTY"},"Out",2,0.16666666666666666,{"$f":"I45*C$45","v":2},{"$f":"SUMIF(Inputs!$A$99:$A$109, E45, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D45, TruckImpacts!F:F)*$L45","v":0.17599999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D45, TruckImpacts!G:G)*$L45","v":0.182}]
[null,null,null,{"$f":"TruckImpacts!A$49","v":"C4F"},{"$f":"TruckImpacts!B$49","v":"PIPE"},{"$f":"TruckImpacts!C$49","v":"Pipe - LOADED"},"In",2,0.16666666666666666,{"$f":"I46*C$45","v":2},{"$f":"SUMIF(Inputs!$A$99:$A$109, E46, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D46, TruckImpacts!F:F)*$L46","v":4.8860000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D46, TruckImpacts!G:G)*$L46","v":8.5619999999999994}]
[null,null,null,{"$f":"TruckImpacts!A$60","v":"C12"},{"$f":"TruckImpacts!B$60","v":"CHEM"},{"$f":"TruckImpacts!C$60","v":"Acid Pump"},"Both",6,0.5,6,{"$f":"SUMIF(Inputs!$A$99:$A$109, E47, Inputs!$G$99:$G$109)/100","v":1},6,{"$f":"SUMIF(TruckImpacts!$A:$A, $D47, TruckImpacts!F:F)*$L47","v":13.937999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D47, TruckImpacts!G:G)*$L47","v":24.324000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$50","v":"C5"},{"$f":"TruckImpacts!B$50","v":"RIG"},{"$f":"TruckImpacts!C$50","v":"Wireline"},"Both",2,0.16666666666666666,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E48, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D48, TruckImpacts!F:F)*$L48","v":4.6879999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D48, TruckImpacts!G:G)*$L48","v":7.13}]
[null,"Fracturing Equipment",{"$f":"TripGen!F10","v":250},{"$f":"TruckImpacts!A$53","v":"C7E"},{"$f":"TruckImpacts!B$53","v":"RIG"},{"$f":"TruckImpacts!C$53","v":"Frac Tank - EMPTY"},"Out",115,0.46,{"$f":"I49*C$49","v":115},{"$f":"SUMIF(Inputs!$A$99:$A$109, E49, Inputs!$G$99:$G$109)/100","v":1},115,{"$f":"SUMIF(TruckImpacts!$A:$A, $D49, TruckImpacts!F:F)*$L49","v":10.234999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D49, TruckImpacts!G:G)*$L49","v":9.66}]
[null,null,null,{"$f":"TruckImpacts!A$54","v":"C7F"},{"$f":"TruckImpacts!B$54","v":"RIG"},{"$f":"TruckImpacts!C$54","v":"Frac Tank - LOADED"},"In",115,0.46,{"$f":"I50*C$49","v":115},{"$f":"SUMIF(Inputs!$A$99:$A$109, E50, Inputs!$G$99:$G$109)/100","v":1},115,{"$f":"SUMIF(TruckImpacts!$A:$A, $D50, TruckImpacts!F:F)*$L50","v":11.155000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D50, TruckImpacts!G:G)*$L50","v":10.925000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$55","v":"C8"},{"$f":"TruckImpacts!B$55","v":"F-WATER"},{"$f":"TruckImpacts!C$55","v":"Pump Truck"},"Both",18,7.1999999999999995E-2,18,{"$f":"SUMIF(Inputs!$A$99:$A$109, E51, Inputs!$G$99:$G$109)/100","v":1},18,{"$f":"SUMIF(TruckImpacts!$A:$A, $D51, TruckImpacts!F:F)*$L51","v":25.794},{"$f":"SUMIF(TruckImpacts!$A:$A, $D51, TruckImpacts!G:G)*$L51","v":46.998000000000005}]
[null,null,null,{"$f":"TruckImpacts!A$56","v":"C9"},{"$f":"TruckImpacts!B$56","v":"RIG"},{"$f":"TruckImpacts!C$56","v":"Control Van"},"Both",2,8.0000000000000002E-3,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E52, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D52, TruckImpacts!F:F)*$L52","v":0.88400000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D52, TruckImpacts!G:G)*$L52","v":1.248}]
[null,"Fracture Water",{"$f":"TripGen!F11","v":7376},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"Out",461,0.5,{"$f":"I53*C$53","v":3688},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E53, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},3688,{"$f":"SUMIF(TruckImpacts!$A:$A, $D53, TruckImpacts!F:F)*$L53","v":276.59999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D53, TruckImpacts!G:G)*$L53","v":287.66399999999999}]
[null,null,null,{"$f":"TruckImpacts!A$44","v":"C2F1"},{"$f":"TruckImpacts!B$44","v":"F-WATER"},{"$f":"TruckImpacts!C$44","v":"Fresh Water - LOADED"},"In",461,0.5,{"$f":"I54*C$53","v":3688},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E54, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},3688,{"$f":"SUMIF(TruckImpacts!$A:$A, $D54, TruckImpacts!F:F)*$L54","v":5236.96},{"$f":"SUMIF(TruckImpacts!$A:$A, $D54, TruckImpacts!G:G)*$L54","v":8862.2639999999992}]
[null,"Fracture Sand",{"$f":"TripGen!F12","v":672},{"$f":"TruckImpacts!A$46","v":"C3E"},{"$f":"TruckImpacts!B$46","v":"SAND"},{"$f":"TruckImpacts!C$46","v":"Sand Truck - EMPTY"},"Out",42,0.5,{"$f":"I55*C$55","v":336},{"$f":"SUMIF(Inputs!$A$99:$A$109, E55, Inputs!$G$99:$G$109)/100","v":1},336,{"$f":"SUMIF(TruckImpacts!$A:$A, $D55, TruckImpacts!F:F)*$L55","v":35.28},{"$f":"SUMIF(TruckImpacts!$A:$A, $D55, TruckImpacts!G:G)*$L55","v":57.456000000000003}]
[null,null,null,{"$f":"TruckImpacts!A$47","v":"C3F"},{"$f":"TruckImpacts!B$47","v":"SAND"},{"$f":"TruckImpacts!C$47","v":"Sand Truck - LOADED"},"In",42,0.5,{"$f":"I56*C$55","v":336},{"$f":"SUMIF(Inputs!$A$99:$A$109, E56, Inputs!$G$99:$G$109)/100","v":1},336,{"$f":"SUMIF(TruckImpacts!$A:$A, $D56, TruckImpacts!F:F)*$L56","v":855.79200000000003},{"$f":"SUMIF(TruckImpacts!$A:$A, $D56, TruckImpacts!G:G)*$L56","v":1524.432}]
[null,"Flowback Water Disposal",{"$f":"TripGen!F13","v":2464},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"In",154,0.5,{"$f":"I57*C$57","v":1232},{"$f":"SUMIF(Inputs!$A$99:$A$109, E57, Inputs!$G$99:$G$109)/100","v":1},1232,{"$f":"SUMIF(TruckImpacts!$A:$A, $D57, TruckImpacts!F:F)*$L57","v":92.399999999999991},{"$f":"SUMIF(TruckImpacts!$A:$A, $D57, TruckImpacts!G:G)*$L57","v":96.096000000000004}]
[null,null,null,{"$f":"TruckImpacts!A$45","v":"C2F2"},{"$f":"TruckImpacts!B$45","v":"P-WATER"},{"$f":"TruckImpacts!C$45","v":"Produced Water - LOADED"},"Out",154,0.5,{"$f":"I58*C$57","v":1232},{"$f":"SUMIF(Inputs!$A$99:$A$109, E58, Inputs!$G$99:$G$109)/100","v":1},1232,{"$f":"SUMIF(TruckImpacts!$A:$A, $D58, TruckImpacts!F:F)*$L58","v":3835.2159999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D58, TruckImpacts!G:G)*$L58","v":6858.5439999999999}]
[null,null,{"$f":"SUM(C2:C58)","v":12370},null,null,null,null,{"$f":"SUM(H2:H58)","v":1940},null,{"$f":"SUM(J2:J58)","v":12370},null,{"$f":"SUM(L2:L58)","v":12370},{"$f":"SUM(M2:M58)","v":12625.291999999999},{"$f":"SUM(N2:N58)","v":21564.038999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt","Concrete"]
[]
["Production (Future)","Check-Ups",{"$f":"TripGen!F40","v":560},{"$f":"TruckImpacts!A66","v":"P3"},{"$f":"TruckImpacts!B66","v":"WORK"},{"$f":"TruckImpacts!C66","v":"Pickup Truck"},"Both",{"$f":"ROUND(TripGen!E$40*(150/446), 0)","v":188},0.33571428571428569,{"$f":"I62*C$62","v":187.99999999999997},{"$f":"SUMIF(Inputs!$A$99:$A$110, E62, Inputs!$G$99:$G$110)/100","v":1},{"$f":"ROUND(J62*K62, 0)","v":188},{"$f":"SUMIF(TruckImpacts!$A:$A, $D62, TruckImpacts!F:F)*$L62","v":0.56400000000000006},{"$f":"SUMIF(TruckImpacts!$A:$A, $D62, TruckImpacts!G:G)*$L62","v":0.56400000000000006}]
[null,"Oil",null,{"$f":"TruckImpacts!A62","v":"P1F"},{"$f":"TruckImpacts!B62","v":"OIL"},{"$f":"TruckImpacts!C62","v":"Oil - LOADED"},"Out",{"$f":"ROUND((TripGen!E$40-H62)*((3/7)/2), 0)","v":80},0.14285714285714285,80,{"$f":"SUMIF(Inputs!$A$99:$A$110, E63, Inputs!$G$99:$G$110)/100","v":1},{"$f":"ROUND(J63*K63, 0)","v":80},{"$f":"SUMIF(TruckImpacts!$A:$A, $D63, TruckImpacts!F:F)*$L63","v":195.44},{"$f":"SUMIF(TruckImpacts!$A:$A, $D63, TruckImpacts!G:G)*$L63","v":342.47999999999996}]
[null,null,null,{"$f":"TruckImpacts!A63","v":"P1E"},{"$f":"TruckImpacts!B63","v":"OIL"},{"$f":"TruckImpacts!C63","v":"Oil - Empty"},"In",{"$f":"H63","v":80},0.14285714285714285,80,{"$f":"SUMIF(Inputs!$A$99:$A$110, E64, Inputs!$G$99:$G$110)/100","v":1},80,{"$f":"SUMIF(TruckImpacts!$A:$A, $D64, TruckImpacts!F:F)*$L64","v":60},{"$f":"SUMIF(TruckImpacts!$A:$A, $D64, TruckImpacts!G:G)*$L64","v":62.400000000000006}]
[null,"Water",null,{"$f":"TruckImpacts!A64","v":"P2E"},{"$f":"TruckImpacts!B64","v":"F-WATER"},{"$f":"TruckImpacts!C64","v":"Water - EMPTY"},"In",{"$f":"(TripGen!E$40-SUM(H62:H64))/2","v":106},0.18928571428571428,106,{"$f":"SUMIF(Inputs!$A$99:$A$110, E65, Inputs!$G$99:$G$110)/100","v":1},106,{"$f":"SUMIF(TruckImpacts!$A:$A, $D65, TruckImpacts!F:F)*$L65","v":79.5},{"$f":"SUMIF(TruckImpacts!$A:$A, $D65, TruckImpacts!G:G)*$L65","v":82.68}]
[null,null,null,{"$f":"TruckImpacts!A65","v":"P2F"},{"$f":"TruckImpacts!B65","v":"P-WATER"},{"$f":"TruckImpacts!C65","v":"Produced Water - LOADED"},"Out",{"$f":"H65","v":106},0.18928571428571428,106,{"$f":"SUMIF(Inputs!$A$99:$A$110, E66, Inputs!$G$99:$G$110)/100","v":1},106,{"$f":"SUMIF(TruckImpacts!$A:$A, $D66, TruckImpacts!F:F)*$L66","v":329.97800000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D66, TruckImpacts!G:G)*$L66","v":590.10199999999998}]
[null,null,{"$f":"SUM(C62:C66)","v":560},null,null,null,null,{"$f":"SUM(H62:H66)","v":560},null,{"$f":"SUM(J62:J66)","v":560},null,{"$f":"SUM(L62:L66)","v":560},{"$f":"SUM(M62:M66)","v":665.48199999999997},{"$f":"SUM(N62:N66)","v":1078.2259999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt","Concrete"]
[]
["Production (Existing)","Check-Ups",{"$f":"TripGen!F41","v":0},{"$f":"TruckImpacts!A66","v":"P3"},{"$f":"TruckImpacts!B66","v":"WORK"},{"$f":"TruckImpacts!C66","v":"Pickup Truck"},"Both",{"$f":"ROUND(TripGen!E$41*(150/446), 0)","v":188},0.33571428571428569,{"$f":"I70*C$70","v":0},{"$f":"SUMIF(Inputs!$A$99:$A$110, E70, Inputs!$G$99:$G$110)/100","v":1},{"$f":"ROUND(J70*K70, 0)","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D70, TruckImpacts!F:F)*$L70","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D70, TruckImpacts!G:G)*$L70","v":0}]
[null,"Oil",null,{"$f":"TruckImpacts!A62","v":"P1F"},{"$f":"TruckImpacts!B62","v":"OIL"},{"$f":"TruckImpacts!C62","v":"Oil - LOADED"},"Out",{"$f":"ROUND((TripGen!E$41-H70)*((3/7)/2), 0)","v":80},0.14285714285714285,{"$f":"I71*C$70","v":0},{"$f":"SUMIF(Inputs!$A$99:$A$110, E71, Inputs!$G$99:$G$110)/100","v":1},{"$f":"ROUND(J71*K71, 0)","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D71, TruckImpacts!F:F)*$L71","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D71, TruckImpacts!G:G)*$L71","v":0}]
[null,null,null,{"$f":"TruckImpacts!A63","v":"P1E"},{"$f":"TruckImpacts!B63","v":"OIL"},{"$f":"TruckImpacts!C63","v":"Oil - Empty"},"In",{"$f":"H71","v":80},0.14285714285714285,{"$f":"I72*C$70","v":0},{"$f":"SUMIF(Inputs!$A$99:$A$110, E72, Inputs!$G$99:$G$110)/100","v":1},0,{"$f":"SUMIF(TruckImpacts!$A:$A, $D72, TruckImpacts!F:F)*$L72","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D72, TruckImpacts!G:G)*$L72","v":0}]
[null,"Water",null,{"$f":"TruckImpacts!A64","v":"P2E"},{"$f":"TruckImpacts!B64","v":"F-WATER"},{"$f":"TruckImpacts!C64","v":"Water - EMPTY"},"In",{"$f":"(TripGen!E$41-SUM(H70:H72))/2","v":106},0.18928571428571428,{"$f":"I73*C$70","v":0},{"$f":"SUMIF(Inputs!$A$99:$A$110, E73, Inputs!$G$99:$G$110)/100","v":1},0,{"$f":"SUMIF(TruckImpacts!$A:$A, $D73, TruckImpacts!F:F)*$L73","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D73, TruckImpacts!G:G)*$L73","v":0}]
[null,null,null,{"$f":"TruckImpacts!A65","v":"P2F"},{"$f":"TruckImpacts!B65","v":"P-WATER"},{"$f":"TruckImpacts!C65","v":"Produced Water - LOADED"},"Out",{"$f":"H73","v":106},0.18928571428571428,{"$f":"I74*C$70","v":0},{"$f":"SUMIF(Inputs!$A$99:$A$110, E74, Inputs!$G$99:$G$110)/100","v":1},0,{"$f":"SUMIF(TruckImpacts!$A:$A, $D74, TruckImpacts!F:F)*$L74","v":0},{"$f":"SUMIF(TruckImpacts!$A:$A, $D74, TruckImpacts!G:G)*$L74","v":0}]
[null,null,{"$f":"SUM(C70:C74)","v":0},null,null,null,null,{"$f":"SUM(H70:H74)","v":560},null,{"$f":"SUM(J70:J74)","v":0},null,{"$f":"SUM(L70:L74)","v":0},{"$f":"SUM(M70:M74)","v":0},{"$f":"SUM(N70:N74)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt","Concrete"]
[]
["Construction (Vertical)","Pad and Road Construction",{"$f":"TripGen!F17","v":64},{"$f":"TruckImpacts!A$3","v":"PC1E"},{"$f":"TruckImpacts!B$3","v":"EQUIP"},{"$f":"TruckImpacts!C$3","v":"Construction Equipment Truck - EMPTY"},"Both",6,9.0909090909090898E-2,{"$f":"I78*C$78","v":5.8181818181818175},{"$f":"SUMIF(Inputs!$A$99:$A$109, E78, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J78*K78, 0)","v":6},{"$f":"SUMIF(TruckImpacts!$A:$A, $D78, TruckImpacts!F:F)*$L78","v":0.52800000000000002},{"$f":"SUMIF(TruckImpacts!$A:$A, $D78, TruckImpacts!G:G)*$L78","v":0.54600000000000004}]
[null,null,null,{"$f":"TruckImpacts!A$4","v":"PC1F"},{"$f":"TruckImpacts!B$4","v":"EQUIP"},{"$f":"TruckImpacts!C$4","v":"Construction Equipment Truck - LOADED"},"Both",6,9.0909090909090912E-2,{"$f":"I79*C$78","v":5.8181818181818183},{"$f":"SUMIF(Inputs!$A$99:$A$109, E79, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J79*K79, 0)","v":6},{"$f":"SUMIF(TruckImpacts!$A:$A, $D79, TruckImpacts!F:F)*$L79","v":6.1259999999999994},{"$f":"SUMIF(TruckImpacts!$A:$A, $D79, TruckImpacts!G:G)*$L79","v":9.9779999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$5","v":"PC2E"},{"$f":"TruckImpacts!B$5","v":"GRAV"},{"$f":"TruckImpacts!C$5","v":"Gravel Truck - EMPTY"},"Out",15,0.22727272727272727,14.545454545454545,{"$f":"SUMIF(Inputs!$A$99:$A$109, E80, Inputs!$G$99:$G$109)/100","v":1},15,{"$f":"SUMIF(TruckImpacts!$A:$A, $D80, TruckImpacts!F:F)*$L80","v":1.5299999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D80, TruckImpacts!G:G)*$L80","v":1.575}]
[null,null,null,{"$f":"TruckImpacts!A$6","v":"PC2F"},{"$f":"TruckImpacts!B$6","v":"GRAV"},{"$f":"TruckImpacts!C$6","v":"Gravel Truck - LOADED"},"In",15,0.22727272727272727,14.545454545454545,{"$f":"SUMIF(Inputs!$A$99:$A$109, E81, Inputs!$G$99:$G$109)/100","v":1},15,{"$f":"SUMIF(TruckImpacts!$A:$A, $D81, TruckImpacts!F:F)*$L81","v":23.474999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D81, TruckImpacts!G:G)*$L81","v":39.449999999999996}]
[null,null,null,{"$f":"TruckImpacts!A$7","v":"PC3"},{"$f":"TruckImpacts!B$7","v":"WORK"},{"$f":"TruckImpacts!C$7","v":"Pickup Truck"},"Both",22,0.34375,{"$f":"I82*C$78","v":22},{"$f":"SUMIF(Inputs!$A$99:$A$109, E82, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J82*K82, 0)","v":22},{"$f":"SUMIF(TruckImpacts!$A:$A, $D82, TruckImpacts!F:F)*$L82","v":6.6000000000000003E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D82, TruckImpacts!G:G)*$L82","v":6.6000000000000003E-2}]
["Drilling (Vertical)","Drilling Rig",{"$f":"TripGen!F18","v":66},{"$f":"TruckImpacts!A$9","v":"D1"},{"$f":"TruckImpacts!B$9","v":"RIG"},{"$f":"TruckImpacts!C$9","v":"Generator House"},"Both",6,9.0909090909090912E-2,{"$f":"I83*C$83","v":6},{"$f":"SUMIF(Inputs!$A$99:$A$109, E83, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J83*K83, 0)","v":6},{"$f":"SUMIF(TruckImpacts!$A:$A, $D83, TruckImpacts!F:F)*$L83","v":23.231999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D83, TruckImpacts!G:G)*$L83","v":56.058}]
[null,null,null,{"$f":"TruckImpacts!A$10","v":"D2"},{"$f":"TruckImpacts!B$10","v":"RIG"},{"$f":"TruckImpacts!C$10","v":"Crown Section"},"Both",2,3.0303030303030304E-2,{"$f":"I84*C$83","v":2},{"$f":"SUMIF(Inputs!$A$99:$A$109, E84, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D84, TruckImpacts!F:F)*$L84","v":16.492000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D84, TruckImpacts!G:G)*$L84","v":31.858000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$11","v":"D3"},{"$f":"TruckImpacts!B$11","v":"RIG"},{"$f":"TruckImpacts!C$11","v":"Shaker Tank/Pit"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E85, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D85, TruckImpacts!F:F)*$L85","v":5.1139999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D85, TruckImpacts!G:G)*$L85","v":12.166}]
[null,null,null,{"$f":"TruckImpacts!A$12","v":"D4"},{"$f":"TruckImpacts!B$12","v":"RIG"},{"$f":"TruckImpacts!C$12","v":"Derrick"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E86, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D86, TruckImpacts!F:F)*$L86","v":16.954000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D86, TruckImpacts!G:G)*$L86","v":36.962000000000003}]
[null,null,null,{"$f":"TruckImpacts!A$13","v":"D5"},{"$f":"TruckImpacts!B$13","v":"RIG"},{"$f":"TruckImpacts!C$13","v":"Suction Tank"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E87, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D87, TruckImpacts!F:F)*$L87","v":5.5460000000000003},{"$f":"SUMIF(TruckImpacts!$A:$A, $D87, TruckImpacts!G:G)*$L87","v":10.84}]
[null,null,null,{"$f":"TruckImpacts!A$14","v":"D6"},{"$f":"TruckImpacts!B$14","v":"RIG"},{"$f":"TruckImpacts!C$14","v":"VFD House"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E88, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D88, TruckImpacts!F:F)*$L88","v":7.3339999999999996},{"$f":"SUMIF(TruckImpacts!$A:$A, $D88, TruckImpacts!G:G)*$L88","v":16.074000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$15","v":"D7"},{"$f":"TruckImpacts!B$15","v":"RIG"},{"$f":"TruckImpacts!C$15","v":"Mud Pump"},"Both",4,6.0606060606060608E-2,4,{"$f":"SUMIF(Inputs!$A$99:$A$109, E89, Inputs!$G$99:$G$109)/100","v":1},4,{"$f":"SUMIF(TruckImpacts!$A:$A, $D89, TruckImpacts!F:F)*$L89","v":22.015999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D89, TruckImpacts!G:G)*$L89","v":51.124000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$16","v":"D8"},{"$f":"TruckImpacts!B$16","v":"RIG"},{"$f":"TruckImpacts!C$16","v":"Mud Boat"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E90, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D90, TruckImpacts!F:F)*$L90","v":10.422000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D90, TruckImpacts!G:G)*$L90","v":22.69}]
[null,null,null,{"$f":"TruckImpacts!A$17","v":"D9"},{"$f":"TruckImpacts!B$17","v":"RIG"},{"$f":"TruckImpacts!C$17","v":"Shaker Skid"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E91, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D91, TruckImpacts!F:F)*$L91","v":10.43},{"$f":"SUMIF(TruckImpacts!$A:$A, $D91, TruckImpacts!G:G)*$L91","v":22.765999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$18","v":"D10"},{"$f":"TruckImpacts!B$18","v":"RIG"},{"$f":"TruckImpacts!C$18","v":"Substructure, etc."},"Both",10,0.15151515151515152,10,{"$f":"SUMIF(Inputs!$A$99:$A$109, E92, Inputs!$G$99:$G$109)/100","v":1},10,{"$f":"SUMIF(TruckImpacts!$A:$A, $D92, TruckImpacts!F:F)*$L92","v":90.13},{"$f":"SUMIF(TruckImpacts!$A:$A, $D92, TruckImpacts!G:G)*$L92","v":149.14999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$19","v":"D11"},{"$f":"TruckImpacts!B$19","v":"RIG"},{"$f":"TruckImpacts!C$19","v":"Draw Works"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E93, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D93, TruckImpacts!F:F)*$L93","v":12.65},{"$f":"SUMIF(TruckImpacts!$A:$A, $D93, TruckImpacts!G:G)*$L93","v":30.094000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$20","v":"D12"},{"$f":"TruckImpacts!B$20","v":"RIG"},{"$f":"TruckImpacts!C$20","v":"Hydraulic Unit"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E94, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D94, TruckImpacts!F:F)*$L94","v":7.9779999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D94, TruckImpacts!G:G)*$L94","v":17.670000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$21","v":"D13"},{"$f":"TruckImpacts!B$21","v":"RIG"},{"$f":"TruckImpacts!C$21","v":"Choke Manifold"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E95, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D95, TruckImpacts!F:F)*$L95","v":12.528},{"$f":"SUMIF(TruckImpacts!$A:$A, $D95, TruckImpacts!G:G)*$L95","v":20.872}]
[null,null,null,{"$f":"TruckImpacts!A$22","v":"D14"},{"$f":"TruckImpacts!B$22","v":"RIG"},{"$f":"TruckImpacts!C$22","v":"MCC House"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E96, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D96, TruckImpacts!F:F)*$L96","v":14.858000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D96, TruckImpacts!G:G)*$L96","v":33.415999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$23","v":"D15"},{"$f":"TruckImpacts!B$23","v":"RIG"},{"$f":"TruckImpacts!C$23","v":"Tool Room / Junk Box"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E97, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D97, TruckImpacts!F:F)*$L97","v":11.93},{"$f":"SUMIF(TruckImpacts!$A:$A, $D97, TruckImpacts!G:G)*$L97","v":27.132000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$24","v":"D16"},{"$f":"TruckImpacts!B$24","v":"RIG"},{"$f":"TruckImpacts!C$24","v":"Screen House"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E98, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D98, TruckImpacts!F:F)*$L98","v":5.2460000000000004},{"$f":"SUMIF(TruckImpacts!$A:$A, $D98, TruckImpacts!G:G)*$L98","v":12.667999999999999}]
[null,null,null,{"$f":"TruckImpacts!A$25","v":"D17"},{"$f":"TruckImpacts!B$25","v":"RIG"},{"$f":"TruckImpacts!C$25","v":"Light Plant"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E99, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D99, TruckImpacts!F:F)*$L99","v":6.68},{"$f":"SUMIF(TruckImpacts!$A:$A, $D99, TruckImpacts!G:G)*$L99","v":17.315999999999999}]
[null,null,null,{"$f":"TruckImpacts!A$26","v":"D18"},{"$f":"TruckImpacts!B$26","v":"RIG"},{"$f":"TruckImpacts!C$26","v":"Mud Tank"},"Both",2,3.0303030303030304E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E100, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D100, TruckImpacts!F:F)*$L100","v":6.9160000000000004},{"$f":"SUMIF(TruckImpacts!$A:$A, $D100, TruckImpacts!G:G)*$L100","v":13.554}]
[null,null,null,{"$f":"TruckImpacts!A$40","v":"D26"},{"$f":"TruckImpacts!B$40","v":"WORK"},{"$f":"TruckImpacts!C$40","v":"Pickup Truck"},"Both",16,0.24242424242424243,{"$f":"I101*C$83","v":16},{"$f":"SUMIF(Inputs!$A$99:$A$109, E101, Inputs!$G$99:$G$109)/100","v":1},16,{"$f":"SUMIF(TruckImpacts!$A:$A, $D101, TruckImpacts!F:F)*$L101","v":4.8000000000000001E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D101, TruckImpacts!G:G)*$L101","v":4.8000000000000001E-2}]
[null,"Drilling Fluid and Materials",{"$f":"TripGen!F19","v":352},{"$f":"TruckImpacts!A$27","v":"D19E"},{"$f":"TruckImpacts!B$27","v":"CEM"},{"$f":"TruckImpacts!C$27","v":"Cement Truck - EMPTY"},"Out",5,0.1125,{"$f":"I102*C$102","v":39.6},{"$f":"SUMIF(Inputs!$A$99:$A$109, E102, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D102, TruckImpacts!F:F)*$L102","v":11.319999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D102, TruckImpacts!G:G)*$L102","v":10.68}]
[null,null,null,{"$f":"TruckImpacts!A$28","v":"D19F"},{"$f":"TruckImpacts!B$28","v":"CEM"},{"$f":"TruckImpacts!C$28","v":"Cement Truck - LOADED"},"In",5,0.1125,{"$f":"I103*C$102","v":39.6},{"$f":"SUMIF(Inputs!$A$99:$A$109, E103, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D103, TruckImpacts!F:F)*$L103","v":93.759999999999991},{"$f":"SUMIF(TruckImpacts!$A:$A, $D103, TruckImpacts!G:G)*$L103","v":142.6}]
[null,null,null,{"$f":"TruckImpacts!A$31","v":"D22E"},{"$f":"TruckImpacts!B$31","v":"CHEM"},{"$f":"TruckImpacts!C$31","v":"Acid Tanker - EMPTY"},"Out",3,6.25E-2,22,{"$f":"SUMIF(Inputs!$A$99:$A$109, E104, Inputs!$G$99:$G$109)/100","v":1},22,{"$f":"SUMIF(TruckImpacts!$A:$A, $D104, TruckImpacts!F:F)*$L104","v":2.3980000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D104, TruckImpacts!G:G)*$L104","v":2.4420000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$32","v":"D22F"},{"$f":"TruckImpacts!B$32","v":"CHEM"},{"$f":"TruckImpacts!C$32","v":"Acid Tanker - LOADED"},"In",3,6.25E-2,22,{"$f":"SUMIF(Inputs!$A$99:$A$109, E105, Inputs!$G$99:$G$109)/100","v":1},22,{"$f":"SUMIF(TruckImpacts!$A:$A, $D105, TruckImpacts!F:F)*$L105","v":68.486000000000004},{"$f":"SUMIF(TruckImpacts!$A:$A, $D105, TruckImpacts!G:G)*$L105","v":122.474}]
[null,null,null,{"$f":"TruckImpacts!A$37","v":"D25E"},{"$f":"TruckImpacts!B$37","v":"F-WATER"},{"$f":"TruckImpacts!C$37","v":"Water - EMPTY"},"Both",{"$f":"SUM(H107:H108)","v":14},{"$f":"SUM(I107:I108)","v":0.32500000000000001},{"$f":"SUM(J107:J108)","v":114.4},null,{"$f":"SUM(L107:L108)","v":114},{"$f":"SUMIF(TruckImpacts!$A:$A, $D106, TruckImpacts!F:F)*$L106","v":8.5499999999999989},{"$f":"SUMIF(TruckImpacts!$A:$A, $D106, TruckImpacts!G:G)*$L106","v":8.8919999999999995}]
[null,null,null,{"$f":"TruckImpacts!A$38","v":"D25F1"},{"$f":"TruckImpacts!B$38","v":"F-WATER"},{"$f":"TruckImpacts!C$38","v":"Fresh Water - LOADED"},"In",7,0.16250000000000001,{"$f":"I107*C$102","v":57.2},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E107, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},{"$f":"ROUND(J107*K107, 0)","v":57},{"$f":"SUMIF(TruckImpacts!$A:$A, $D107, TruckImpacts!F:F)*$L107","v":80.94},{"$f":"SUMIF(TruckImpacts!$A:$A, $D107, TruckImpacts!G:G)*$L107","v":136.971}]
[null,null,null,{"$f":"TruckImpacts!A$39","v":"D25F2"},{"$f":"TruckImpacts!B$39","v":"P-WATER"},{"$f":"TruckImpacts!C$39","v":"Produced Water - LOADED"},"Out",7,0.16250000000000001,57.2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E108, Inputs!$G$99:$G$109)/100","v":1},57,{"$f":"SUMIF(TruckImpacts!$A:$A, $D108, TruckImpacts!F:F)*$L108","v":177.441},{"$f":"SUMIF(TruckImpacts!$A:$A, $D108, TruckImpacts!G:G)*$L108","v":317.31900000000002}]
[null,"Drilling Equipment",{"$f":"TripGen!F20","v":480},{"$f":"TruckImpacts!A$29","v":"D20"},{"$f":"TruckImpacts!B$29","v":"CEM"},{"$f":"TruckImpacts!C$29","v":"Cement Pump"},"Both",12,0.2,{"$f":"I109*C$109","v":96},{"$f":"SUMIF(Inputs!$A$99:$A$109, E109, Inputs!$G$99:$G$109)/100","v":1},96,{"$f":"SUMIF(TruckImpacts!$A:$A, $D109, TruckImpacts!F:F)*$L109","v":145.92000000000002},{"$f":"SUMIF(TruckImpacts!$A:$A, $D109, TruckImpacts!G:G)*$L109","v":255.93599999999998}]
[null,null,null,{"$f":"TruckImpacts!A$30","v":"D21"},{"$f":"TruckImpacts!B$30","v":"CHEM"},{"$f":"TruckImpacts!C$30","v":"Acid Pump"},"Both",4,6.6666666666666666E-2,{"$f":"I110*C$109","v":32},{"$f":"SUMIF(Inputs!$A$99:$A$109, E110, Inputs!$G$99:$G$109)/100","v":1},32,{"$f":"SUMIF(TruckImpacts!$A:$A, $D110, TruckImpacts!F:F)*$L110","v":74.335999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D110, TruckImpacts!G:G)*$L110","v":129.72800000000001}]
[null,null,null,{"$f":"TruckImpacts!A$35","v":"D24E"},{"$f":"TruckImpacts!B$35","v":"FUEL"},{"$f":"TruckImpacts!C$35","v":"Fuel Truck - EMPTY"},"Out",8,0.13333333333333333,{"$f":"I111*C$109","v":64},{"$f":"SUMIF(Inputs!$A$99:$A$109, E111, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D111, TruckImpacts!F:F)*$L111","v":18.111999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D111, TruckImpacts!G:G)*$L111","v":17.088000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$36","v":"D24F"},{"$f":"TruckImpacts!B$36","v":"FUEL"},{"$f":"TruckImpacts!C$36","v":"Fuel Truck - LOADED"},"In",8,0.13333333333333333,64,{"$f":"SUMIF(Inputs!$A$99:$A$109, E112, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D112, TruckImpacts!F:F)*$L112","v":150.01599999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D112, TruckImpacts!G:G)*$L112","v":228.16}]
[null,null,null,{"$f":"TruckImpacts!A$33","v":"D23E"},{"$f":"TruckImpacts!B$33","v":"PIPE"},{"$f":"TruckImpacts!C$33","v":"Pipe - EMPTY"},"Out",14,0.23333333333333334,112,{"$f":"SUMIF(Inputs!$A$99:$A$109, E113, Inputs!$G$99:$G$109)/100","v":1},112,{"$f":"SUMIF(TruckImpacts!$A:$A, $D113, TruckImpacts!F:F)*$L113","v":9.8559999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D113, TruckImpacts!G:G)*$L113","v":10.192}]
[null,null,null,{"$f":"TruckImpacts!A$34","v":"D23F"},{"$f":"TruckImpacts!B$34","v":"PIPE"},{"$f":"TruckImpacts!C$34","v":"Pipe - LOADED"},"In",14,0.23333333333333334,112,{"$f":"SUMIF(Inputs!$A$99:$A$109, E114, Inputs!$G$99:$G$109)/100","v":1},112,{"$f":"SUMIF(TruckImpacts!$A:$A, $D114, TruckImpacts!F:F)*$L114","v":273.61599999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D114, TruckImpacts!G:G)*$L114","v":479.47199999999998}]
["Completion (Vertical)","Completion Rig",{"$f":"TripGen!F21","v":22},{"$f":"TruckImpacts!A$42","v":"C1"},{"$f":"TruckImpacts!B$42","v":"RIG"},{"$f":"TruckImpacts!C$42","v":"Workover Rig"},"Both",4,0.1875,{"$f":"I115*C115","v":4.125},{"$f":"SUMIF(Inputs!$A$99:$A$109, E115, Inputs!$G$99:$G$109)/100","v":1},4,{"$f":"SUMIF(TruckImpacts!$A:$A, $D115, TruckImpacts!F:F)*$L115","v":23.103999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D115, TruckImpacts!G:G)*$L115","v":53.567999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$59","v":"C11"},{"$f":"TruckImpacts!B$59","v":"WORK"},{"$f":"TruckImpacts!C$59","v":"Pickup Truck"},"Both",18,0.8125,{"$f":"I116*C115","v":17.875},{"$f":"SUMIF(Inputs!$A$99:$A$109, E116, Inputs!$G$99:$G$109)/100","v":1},18,{"$f":"SUMIF(TruckImpacts!$A:$A, $D116, TruckImpacts!F:F)*$L116","v":5.3999999999999999E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D116, TruckImpacts!G:G)*$L116","v":5.3999999999999999E-2}]
[null,"Completion Fluid and Materials",{"$f":"TripGen!F22","v":192},{"$f":"TruckImpacts!A$51","v":"C6E"},{"$f":"TruckImpacts!B$51","v":"CHEM"},{"$f":"TruckImpacts!C$51","v":"Chemical Truck - EMPTY"},"Out",7,0.29166666666666669,{"$f":"I117*C$117","v":56},{"$f":"SUMIF(Inputs!$A$99:$A$109, E117, Inputs!$G$99:$G$109)/100","v":1},56,{"$f":"SUMIF(TruckImpacts!$A:$A, $D117, TruckImpacts!F:F)*$L117","v":15.847999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D117, TruckImpacts!G:G)*$L117","v":14.952000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$52","v":"C6F"},{"$f":"TruckImpacts!B$52","v":"CHEM"},{"$f":"TruckImpacts!C$52","v":"Chemical Truck - LOADED"},"In",7,0.29166666666666669,{"$f":"I118*C$117","v":56},{"$f":"SUMIF(Inputs!$A$99:$A$109, E118, Inputs!$G$99:$G$109)/100","v":1},56,{"$f":"SUMIF(TruckImpacts!$A:$A, $D118, TruckImpacts!F:F)*$L118","v":131.26399999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D118, TruckImpacts!G:G)*$L118","v":199.64}]
[null,null,null,{"$f":"TruckImpacts!A$57","v":"C10E"},{"$f":"TruckImpacts!B$57","v":"FUEL"},{"$f":"TruckImpacts!C$57","v":"Fuel Truck - EMPTY"},"Out",5,0.20833333333333334,40,{"$f":"SUMIF(Inputs!$A$99:$A$109, E119, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D119, TruckImpacts!F:F)*$L119","v":11.319999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D119, TruckImpacts!G:G)*$L119","v":10.68}]
[null,null,null,{"$f":"TruckImpacts!A$58","v":"C10F"},{"$f":"TruckImpacts!B$58","v":"FUEL"},{"$f":"TruckImpacts!C$58","v":"Fuel Truck - LOADED"},"In",5,0.20833333333333334,40,{"$f":"SUMIF(Inputs!$A$99:$A$109, E120, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D120, TruckImpacts!F:F)*$L120","v":93.759999999999991},{"$f":"SUMIF(TruckImpacts!$A:$A, $D120, TruckImpacts!G:G)*$L120","v":142.6}]
[null,"Completion Equipment",{"$f":"TripGen!F23","v":8},{"$f":"TruckImpacts!A$48","v":"C4E"},{"$f":"TruckImpacts!B$48","v":"PIPE"},{"$f":"TruckImpacts!C$48","v":"Pipe - EMPTY"},"Out",1,0.125,{"$f":"I121*C$121","v":1},{"$f":"SUMIF(Inputs!$A$99:$A$109, E121, Inputs!$G$99:$G$109)/100","v":1},1,{"$f":"SUMIF(TruckImpacts!$A:$A, $D121, TruckImpacts!F:F)*$L121","v":8.7999999999999995E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D121, TruckImpacts!G:G)*$L121","v":9.0999999999999998E-2}]
[null,null,null,{"$f":"TruckImpacts!A$49","v":"C4F"},{"$f":"TruckImpacts!B$49","v":"PIPE"},{"$f":"TruckImpacts!C$49","v":"Pipe - LOADED"},"In",1,0.125,{"$f":"I122*C$121","v":1},{"$f":"SUMIF(Inputs!$A$99:$A$109, E122, Inputs!$G$99:$G$109)/100","v":1},1,{"$f":"SUMIF(TruckImpacts!$A:$A, $D122, TruckImpacts!F:F)*$L122","v":2.4430000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D122, TruckImpacts!G:G)*$L122","v":4.2809999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$60","v":"C12"},{"$f":"TruckImpacts!B$60","v":"CHEM"},{"$f":"TruckImpacts!C$60","v":"Acid Pump"},"Both",4,0.5,4,{"$f":"SUMIF(Inputs!$A$99:$A$109, E123, Inputs!$G$99:$G$109)/100","v":1},4,{"$f":"SUMIF(TruckImpacts!$A:$A, $D123, TruckImpacts!F:F)*$L123","v":9.2919999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D123, TruckImpacts!G:G)*$L123","v":16.216000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$50","v":"C5"},{"$f":"TruckImpacts!B$50","v":"RIG"},{"$f":"TruckImpacts!C$50","v":"Wireline"},"Both",2,0.25,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E124, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D124, TruckImpacts!F:F)*$L124","v":4.6879999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D124, TruckImpacts!G:G)*$L124","v":7.13}]
[null,"Fracturing Equipment",{"$f":"TripGen!F24","v":146},{"$f":"TruckImpacts!A$53","v":"C7E"},{"$f":"TruckImpacts!B$53","v":"RIG"},{"$f":"TruckImpacts!C$53","v":"Frac Tank - EMPTY"},"Out",69,0.4726027397260274,{"$f":"I125*C$125","v":69},{"$f":"SUMIF(Inputs!$A$99:$A$109, E125, Inputs!$G$99:$G$109)/100","v":1},69,{"$f":"SUMIF(TruckImpacts!$A:$A, $D125, TruckImpacts!F:F)*$L125","v":6.141},{"$f":"SUMIF(TruckImpacts!$A:$A, $D125, TruckImpacts!G:G)*$L125","v":5.7960000000000003}]
[null,null,null,{"$f":"TruckImpacts!A$54","v":"C7F"},{"$f":"TruckImpacts!B$54","v":"RIG"},{"$f":"TruckImpacts!C$54","v":"Frac Tank - LOADED"},"In",69,0.4726027397260274,{"$f":"I126*C$125","v":69},{"$f":"SUMIF(Inputs!$A$99:$A$109, E126, Inputs!$G$99:$G$109)/100","v":1},69,{"$f":"SUMIF(TruckImpacts!$A:$A, $D126, TruckImpacts!F:F)*$L126","v":6.6930000000000005},{"$f":"SUMIF(TruckImpacts!$A:$A, $D126, TruckImpacts!G:G)*$L126","v":6.5549999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$55","v":"C8"},{"$f":"TruckImpacts!B$55","v":"F-WATER"},{"$f":"TruckImpacts!C$55","v":"Pump Truck"},"Both",6,4.1095890410958902E-2,6,{"$f":"SUMIF(Inputs!$A$99:$A$109, E127, Inputs!$G$99:$G$109)/100","v":1},6,{"$f":"SUMIF(TruckImpacts!$A:$A, $D127, TruckImpacts!F:F)*$L127","v":8.5980000000000008},{"$f":"SUMIF(TruckImpacts!$A:$A, $D127, TruckImpacts!G:G)*$L127","v":15.666}]
[null,null,null,{"$f":"TruckImpacts!A$56","v":"C9"},{"$f":"TruckImpacts!B$56","v":"RIG"},{"$f":"TruckImpacts!C$56","v":"Control Van"},"Both",2,1.3698630136986301E-2,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E128, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D128, TruckImpacts!F:F)*$L128","v":0.88400000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D128, TruckImpacts!G:G)*$L128","v":1.248}]
[null,"Fracture Water",{"$f":"TripGen!F25","v":1968},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"Out",123,0.5,{"$f":"I129*C$129","v":984},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E129, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},984,{"$f":"SUMIF(TruckImpacts!$A:$A, $D129, TruckImpacts!F:F)*$L129","v":73.8},{"$f":"SUMIF(TruckImpacts!$A:$A, $D129, TruckImpacts!G:G)*$L129","v":76.751999999999995}]
[null,null,null,{"$f":"TruckImpacts!A$44","v":"C2F1"},{"$f":"TruckImpacts!B$44","v":"F-WATER"},{"$f":"TruckImpacts!C$44","v":"Fresh Water - LOADED"},"In",123,0.5,{"$f":"I130*C$129","v":984},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E130, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},984,{"$f":"SUMIF(TruckImpacts!$A:$A, $D130, TruckImpacts!F:F)*$L130","v":1397.28},{"$f":"SUMIF(TruckImpacts!$A:$A, $D130, TruckImpacts!G:G)*$L130","v":2364.5520000000001}]
[null,"Fracture Sand",{"$f":"TripGen!F26","v":128},{"$f":"TruckImpacts!A$46","v":"C3E"},{"$f":"TruckImpacts!B$46","v":"SAND"},{"$f":"TruckImpacts!C$46","v":"Sand Truck - EMPTY"},"Out",8,0.5,{"$f":"I131*C$131","v":64},{"$f":"SUMIF(Inputs!$A$99:$A$109, E131, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D131, TruckImpacts!F:F)*$L131","v":6.72},{"$f":"SUMIF(TruckImpacts!$A:$A, $D131, TruckImpacts!G:G)*$L131","v":10.944000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$47","v":"C3F"},{"$f":"TruckImpacts!B$47","v":"SAND"},{"$f":"TruckImpacts!C$47","v":"Sand Truck - LOADED"},"In",8,0.5,{"$f":"I132*C$131","v":64},{"$f":"SUMIF(Inputs!$A$99:$A$109, E132, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D132, TruckImpacts!F:F)*$L132","v":163.00800000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D132, TruckImpacts!G:G)*$L132","v":290.36799999999999}]
[null,"Flowback Water Disposal",{"$f":"TripGen!F27","v":816},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"In",51,0.5,{"$f":"I133*C$133","v":408},{"$f":"SUMIF(Inputs!$A$99:$A$109, E133, Inputs!$G$99:$G$109)/100","v":1},408,{"$f":"SUMIF(TruckImpacts!$A:$A, $D133, TruckImpacts!F:F)*$L133","v":30.599999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D133, TruckImpacts!G:G)*$L133","v":31.824000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$45","v":"C2F2"},{"$f":"TruckImpacts!B$45","v":"P-WATER"},{"$f":"TruckImpacts!C$45","v":"Produced Water - LOADED"},"Out",51,0.5,{"$f":"I134*C$133","v":408},{"$f":"SUMIF(Inputs!$A$99:$A$109, E134, Inputs!$G$99:$G$109)/100","v":1},408,{"$f":"SUMIF(TruckImpacts!$A:$A, $D134, TruckImpacts!F:F)*$L134","v":1270.104},{"$f":"SUMIF(TruckImpacts!$A:$A, $D134, TruckImpacts!G:G)*$L134","v":2271.3360000000002}]
[null,null,{"$f":"SUM(C78:C134)","v":4242},null,null,null,null,{"$f":"SUM(H78:H134)","v":798},null,{"$f":"SUM(J78:J134)","v":4240.727272727273},null,{"$f":"SUM(L78:L134)","v":4242},{"$f":"SUM(M78:M134)","v":4688.6689999999999},{"$f":"SUM(N78:N134)","v":8020.2800000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt","Concrete"]
[]
["Vertical Recompletion","Completion Rig",{"$f":"TripGen!F31","v":22},{"$f":"TruckImpacts!A$42","v":"C1"},{"$f":"TruckImpacts!B$42","v":"RIG"},{"$f":"TruckImpacts!C$42","v":"Workover Rig"},"Both",4,0.1875,{"$f":"I138*C138","v":4.125},{"$f":"SUMIF(Inputs!$A$99:$A$109, E138, Inputs!$G$99:$G$109)/100","v":1},{"$f":"ROUND(J138*K138, 0)","v":4},{"$f":"SUMIF(TruckImpacts!$A:$A, $D138, TruckImpacts!F:F)*$L138","v":23.103999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D138, TruckImpacts!G:G)*$L138","v":53.567999999999998}]
[null,null,null,{"$f":"TruckImpacts!A$59","v":"C11"},{"$f":"TruckImpacts!B$59","v":"WORK"},{"$f":"TruckImpacts!C$59","v":"Pickup Truck"},"Both",18,0.8125,{"$f":"I139*C138","v":17.875},{"$f":"SUMIF(Inputs!$A$99:$A$109, E139, Inputs!$G$99:$G$109)/100","v":1},18,{"$f":"SUMIF(TruckImpacts!$A:$A, $D139, TruckImpacts!F:F)*$L139","v":5.3999999999999999E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D139, TruckImpacts!G:G)*$L139","v":5.3999999999999999E-2}]
[null,"Completion Fluid and Materials",{"$f":"TripGen!F32","v":192},{"$f":"TruckImpacts!A$51","v":"C6E"},{"$f":"TruckImpacts!B$51","v":"CHEM"},{"$f":"TruckImpacts!C$51","v":"Chemical Truck - EMPTY"},"Out",7,0.29166666666666669,{"$f":"I140*C$140","v":56},{"$f":"SUMIF(Inputs!$A$99:$A$109, E140, Inputs!$G$99:$G$109)/100","v":1},56,{"$f":"SUMIF(TruckImpacts!$A:$A, $D140, TruckImpacts!F:F)*$L140","v":15.847999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D140, TruckImpacts!G:G)*$L140","v":14.952000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$52","v":"C6F"},{"$f":"TruckImpacts!B$52","v":"CHEM"},{"$f":"TruckImpacts!C$52","v":"Chemical Truck - LOADED"},"In",7,0.29166666666666669,{"$f":"I141*C$140","v":56},{"$f":"SUMIF(Inputs!$A$99:$A$109, E141, Inputs!$G$99:$G$109)/100","v":1},56,{"$f":"SUMIF(TruckImpacts!$A:$A, $D141, TruckImpacts!F:F)*$L141","v":131.26399999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D141, TruckImpacts!G:G)*$L141","v":199.64}]
[null,null,null,{"$f":"TruckImpacts!A$57","v":"C10E"},{"$f":"TruckImpacts!B$57","v":"FUEL"},{"$f":"TruckImpacts!C$57","v":"Fuel Truck - EMPTY"},"Out",5,0.20833333333333334,40,{"$f":"SUMIF(Inputs!$A$99:$A$109, E142, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D142, TruckImpacts!F:F)*$L142","v":11.319999999999999},{"$f":"SUMIF(TruckImpacts!$A:$A, $D142, TruckImpacts!G:G)*$L142","v":10.68}]
[null,null,null,{"$f":"TruckImpacts!A$58","v":"C10F"},{"$f":"TruckImpacts!B$58","v":"FUEL"},{"$f":"TruckImpacts!C$58","v":"Fuel Truck - LOADED"},"In",5,0.20833333333333334,{"$f":"I143*C$140","v":40},{"$f":"SUMIF(Inputs!$A$99:$A$109, E143, Inputs!$G$99:$G$109)/100","v":1},40,{"$f":"SUMIF(TruckImpacts!$A:$A, $D143, TruckImpacts!F:F)*$L143","v":93.759999999999991},{"$f":"SUMIF(TruckImpacts!$A:$A, $D143, TruckImpacts!G:G)*$L143","v":142.6}]
[null,"Completion Equipment",{"$f":"TripGen!F33","v":8},{"$f":"TruckImpacts!A$48","v":"C4E"},{"$f":"TruckImpacts!B$48","v":"PIPE"},{"$f":"TruckImpacts!C$48","v":"Pipe - EMPTY"},"Out",1,0.125,{"$f":"I144*C$144","v":1},{"$f":"SUMIF(Inputs!$A$99:$A$109, E144, Inputs!$G$99:$G$109)/100","v":1},1,{"$f":"SUMIF(TruckImpacts!$A:$A, $D144, TruckImpacts!F:F)*$L144","v":8.7999999999999995E-2},{"$f":"SUMIF(TruckImpacts!$A:$A, $D144, TruckImpacts!G:G)*$L144","v":9.0999999999999998E-2}]
[null,null,null,{"$f":"TruckImpacts!A$49","v":"C4F"},{"$f":"TruckImpacts!B$49","v":"PIPE"},{"$f":"TruckImpacts!C$49","v":"Pipe - LOADED"},"In",1,0.125,{"$f":"I145*C$144","v":1},{"$f":"SUMIF(Inputs!$A$99:$A$109, E145, Inputs!$G$99:$G$109)/100","v":1},1,{"$f":"SUMIF(TruckImpacts!$A:$A, $D145, TruckImpacts!F:F)*$L145","v":2.4430000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D145, TruckImpacts!G:G)*$L145","v":4.2809999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$60","v":"C12"},{"$f":"TruckImpacts!B$60","v":"CHEM"},{"$f":"TruckImpacts!C$60","v":"Acid Pump"},"Both",4,0.5,4,{"$f":"SUMIF(Inputs!$A$99:$A$109, E146, Inputs!$G$99:$G$109)/100","v":1},4,{"$f":"SUMIF(TruckImpacts!$A:$A, $D146, TruckImpacts!F:F)*$L146","v":9.2919999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D146, TruckImpacts!G:G)*$L146","v":16.216000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$50","v":"C5"},{"$f":"TruckImpacts!B$50","v":"RIG"},{"$f":"TruckImpacts!C$50","v":"Wireline"},"Both",2,0.25,2,{"$f":"SUMIF(Inputs!$A$99:$A$109, E147, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D147, TruckImpacts!F:F)*$L147","v":4.6879999999999997},{"$f":"SUMIF(TruckImpacts!$A:$A, $D147, TruckImpacts!G:G)*$L147","v":7.13}]
[null,"Fracturing Equipment",{"$f":"TripGen!F34","v":146},{"$f":"TruckImpacts!A$53","v":"C7E"},{"$f":"TruckImpacts!B$53","v":"RIG"},{"$f":"TruckImpacts!C$53","v":"Frac Tank - EMPTY"},"Out",69,0.4726027397260274,{"$f":"I148*C$148","v":69},{"$f":"SUMIF(Inputs!$A$99:$A$109, E148, Inputs!$G$99:$G$109)/100","v":1},69,{"$f":"SUMIF(TruckImpacts!$A:$A, $D148, TruckImpacts!F:F)*$L148","v":6.141},{"$f":"SUMIF(TruckImpacts!$A:$A, $D148, TruckImpacts!G:G)*$L148","v":5.7960000000000003}]
[null,null,null,{"$f":"TruckImpacts!A$54","v":"C7F"},{"$f":"TruckImpacts!B$54","v":"RIG"},{"$f":"TruckImpacts!C$54","v":"Frac Tank - LOADED"},"In",69,0.4726027397260274,{"$f":"I149*C$148","v":69},{"$f":"SUMIF(Inputs!$A$99:$A$109, E149, Inputs!$G$99:$G$109)/100","v":1},69,{"$f":"SUMIF(TruckImpacts!$A:$A, $D149, TruckImpacts!F:F)*$L149","v":6.6930000000000005},{"$f":"SUMIF(TruckImpacts!$A:$A, $D149, TruckImpacts!G:G)*$L149","v":6.5549999999999997}]
[null,null,null,{"$f":"TruckImpacts!A$55","v":"C8"},{"$f":"TruckImpacts!B$55","v":"F-WATER"},{"$f":"TruckImpacts!C$55","v":"Pump Truck"},"Both",6,4.1095890410958902E-2,6,{"$f":"SUMIF(Inputs!$A$99:$A$109, E150, Inputs!$G$99:$G$109)/100","v":1},6,{"$f":"SUMIF(TruckImpacts!$A:$A, $D150, TruckImpacts!F:F)*$L150","v":8.5980000000000008},{"$f":"SUMIF(TruckImpacts!$A:$A, $D150, TruckImpacts!G:G)*$L150","v":15.666}]
[null,null,null,{"$f":"TruckImpacts!A$56","v":"C9"},{"$f":"TruckImpacts!B$56","v":"RIG"},{"$f":"TruckImpacts!C$56","v":"Control Van"},"Both",2,1.3698630136986301E-2,{"$f":"I151*C$148","v":2},{"$f":"SUMIF(Inputs!$A$99:$A$109, E151, Inputs!$G$99:$G$109)/100","v":1},2,{"$f":"SUMIF(TruckImpacts!$A:$A, $D151, TruckImpacts!F:F)*$L151","v":0.88400000000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D151, TruckImpacts!G:G)*$L151","v":1.248}]
[null,"Fracture Water",{"$f":"TripGen!F35","v":1968},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"Out",123,0.5,{"$f":"I152*C$152","v":984},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E152, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},984,{"$f":"SUMIF(TruckImpacts!$A:$A, $D152, TruckImpacts!F:F)*$L152","v":73.8},{"$f":"SUMIF(TruckImpacts!$A:$A, $D152, TruckImpacts!G:G)*$L152","v":76.751999999999995}]
[null,null,null,{"$f":"TruckImpacts!A$44","v":"C2F1"},{"$f":"TruckImpacts!B$44","v":"F-WATER"},{"$f":"TruckImpacts!C$44","v":"Fresh Water - LOADED"},"In",123,0.5,{"$f":"I153*C$152","v":984},{"$f":"(SUMIF(Inputs!$A$99:$A$109, E153, Inputs!$G$99:$G$109)/100)*IF(Inputs!$G$78=\"Yes\", 0, 1)","v":1},984,{"$f":"SUMIF(TruckImpacts!$A:$A, $D153, TruckImpacts!F:F)*$L153","v":1397.28},{"$f":"SUMIF(TruckImpacts!$A:$A, $D153, TruckImpacts!G:G)*$L153","v":2364.5520000000001}]
[null,"Fracture Sand",{"$f":"TripGen!F36","v":128},{"$f":"TruckImpacts!A$46","v":"C3E"},{"$f":"TruckImpacts!B$46","v":"SAND"},{"$f":"TruckImpacts!C$46","v":"Sand Truck - EMPTY"},"Out",8,0.5,{"$f":"I154*C$154","v":64},{"$f":"SUMIF(Inputs!$A$99:$A$109, E154, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D154, TruckImpacts!F:F)*$L154","v":6.72},{"$f":"SUMIF(TruckImpacts!$A:$A, $D154, TruckImpacts!G:G)*$L154","v":10.944000000000001}]
[null,null,null,{"$f":"TruckImpacts!A$47","v":"C3F"},{"$f":"TruckImpacts!B$47","v":"SAND"},{"$f":"TruckImpacts!C$47","v":"Sand Truck - LOADED"},"In",8,0.5,{"$f":"I155*C$154","v":64},{"$f":"SUMIF(Inputs!$A$99:$A$109, E155, Inputs!$G$99:$G$109)/100","v":1},64,{"$f":"SUMIF(TruckImpacts!$A:$A, $D155, TruckImpacts!F:F)*$L155","v":163.00800000000001},{"$f":"SUMIF(TruckImpacts!$A:$A, $D155, TruckImpacts!G:G)*$L155","v":290.36799999999999}]
[null,"Flowback Water Disposal",{"$f":"TripGen!F37","v":816},{"$f":"TruckImpacts!A$43","v":"C2E"},{"$f":"TruckImpacts!B$43","v":"F-WATER"},{"$f":"TruckImpacts!C$43","v":"Water - EMPTY"},"In",51,0.5,{"$f":"I156*C$156","v":408},{"$f":"SUMIF(Inputs!$A$99:$A$109, E156, Inputs!$G$99:$G$109)/100","v":1},408,{"$f":"SUMIF(TruckImpacts!$A:$A, $D156, TruckImpacts!F:F)*$L156","v":30.599999999999998},{"$f":"SUMIF(TruckImpacts!$A:$A, $D156, TruckImpacts!G:G)*$L156","v":31.824000000000002}]
[null,null,null,{"$f":"TruckImpacts!A$45","v":"C2F2"},{"$f":"TruckImpacts!B$45","v":"P-WATER"},{"$f":"TruckImpacts!C$45","v":"Produced Water - LOADED"},"Out",51,0.5,{"$f":"I157*C$156","v":408},{"$f":"SUMIF(Inputs!$A$99:$A$109, E157, Inputs!$G$99:$G$109)/100","v":1},408,{"$f":"SUMIF(TruckImpacts!$A:$A, $D157, TruckImpacts!F:F)*$L157","v":1270.104},{"$f":"SUMIF(TruckImpacts!$A:$A, $D157, TruckImpacts!G:G)*$L157","v":2271.3360000000002}]
[null,null,{"$f":"SUM(C138:C157)","v":3280},null,null,null,null,{"$f":"SUM(H138:H157)","v":564},null,{"$f":"SUM(J138:J157)","v":3280},null,{"$f":"SUM(L138:L157)","v":3280},{"$f":"SUM(M138:M157)","v":3255.6890000000003},5524.2530000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt","Concrete"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DEV VALUES TO USE"]
[null,null,null,null,null,null,null,null,null,null,null,"Mod","Asphalt","Concrete"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$G76=\"Horizontal\", L59, IF(Inputs!$G76=\"Vertical\", L135, IF(Inputs!$G76=\"Recompletion\", L158, 0)))","v":12370},{"$f":"IF(Inputs!$G76=\"Horizontal\", M59, IF(Inputs!$G76=\"Vertical\", M135, IF(Inputs!$G76=\"Recompletion\", M158, 0)))","v":12625.291999999999},{"$f":"IF(Inputs!$G76=\"Horizontal\", N59, IF(Inputs!$G76=\"Vertical\", N135, IF(Inputs!$G76=\"Recompletion\", N158, 0)))","v":21564.038999999997}]

{"sheet":"RoadwayConstants","index":6,"n_rows":141,"n_cols":13,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
["LOC","TOPO","CLASS","REGION","Reliability","Std Normal Deviate","Resilient Modulus","K-Value","Serv Loss","ESALs HMA","ESALs PCCP","SN HMA","Thick PCCP"]
["Urban","Plains","Interstate","R1",95,-1.645,7800,125,2,41225509.267375253,69162413.865162417,5.93,13.25]
["Urban","Mountains","Interstate","R1",95,-1.645,25000,250,2]
["Rural","Plains","Interstate","R1",95,-1.645,7800,125,2,21123879.997628432,33343201.953071631,5.43,11.75]
["Rural","Mountains","Interstate","R1",95,-1.645,25000,250,2,16037300.14420457,24669916.75360262,3.7,11]
["Urban","Plains","Principal Arterial","R1",95,-1.645,7800,125,2,14904244.57267868,23204954.611675631,5.18,11]
["Urban","Mountains","Principal Arterial","R1",95,-1.645,25000,250,2]
["Rural","Plains","Principal Arterial","R1",95,-1.645,7800,125,2,13119668.108374091,null,5.09]
["Rural","Mountains","Principal Arterial","R1",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial - Others","R1",95,-1.645,7800,125,2,5137528.6915997174,8403349.8139379639,4.47,9.5]
["Urban","Mountains","Principal Arterial - Others","R1",95,-1.645,25000,250,2]
["Rural","Plains","Principal Arterial - Others","R1",95,-1.645,7800,125,2,3556295.1776499678,7157386.1246911399,4.24,9.25]
["Rural","Mountains","Principal Arterial - Others","R1",95,-1.645,25000,250,2,3307053.2311240924,8878967.5461789295,2.77,9.25]
["Urban","Plains","Minor Arterial","R1",95,-1.645,7800,125,2,3231454.4176139506,5419470.5973551767,4.18,8.75]
["Urban","Mountains","Minor Arterial","R1",95,-1.645,25000,250,2,1550946.3672458443,829801.14986721799,2.46,6]
["Rural","Plains","Minor Arterial","R1",95,-1.645,7800,125,2,2060232.3584799888,null,3.91]
["Rural","Mountains","Minor Arterial","R1",95,-1.645,25000,250,2,1406336.353371328,4640338.5105271963,2.42,8.25]
["Urban","Plains","Major Collector","R1",90,-1.282,7800,125,2,740773.12979968486,null,3.16]
["Urban","Mountains","Major Collector","R1",90,-1.282,25000,250,2]
["Rural","Plains","Major Collector","R1",90,-1.282,7800,125,2,1679944.531653228,null,3.59]
["Rural","Mountains","Major Collector","R1",90,-1.282,25000,250,2,374168.48979617655,null,1.83]
["Urban","Plains","Minor Collector","R1",90,-1.282,7800,125,2.5]
["Urban","Mountains","Minor Collector","R1",90,-1.282,25000,250,2.5]
["Rural","Plains","Minor Collector","R1",90,-1.282,7800,125,2.5,543105.05101017689,null,2.93]
["Rural","Mountains","Minor Collector","R1",90,-1.282,25000,250,2.5,287894.56823657197,null,1.74]
["Urban","Plains","Local","R1",80,-0.84099999999999997,7800,125,2.5]
["Urban","Mountains","Local","R1",80,-0.84099999999999997,25000,250,2.5]
["Rural","Plains","Local","R1",80,-0.84099999999999997,7800,125,2.5,69169.938030538528,null,1.99]
["Rural","Mountains","Local","R1",80,-0.84099999999999997,25000,250,2.5]
["Urban","Plains","Interstate","R2",95,-1.645,7800,125,2,24794357.162770297,48464345.672795467,5.55,12.25]
["Urban","Mountains","Interstate","R2",95,-1.645,25000,250,2]
["Rural","Plains","Interstate","R2",95,-1.645,7800,125,2,12529324.712134626,null,5.0599999999999996]
["Rural","Mountains","Interstate","R2",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial","R2",95,-1.645,7800,125,2,8124995.3794377893,12628287.725883136,4.7699999999999996,10]
["Urban","Mountains","Principal Arterial","R2",95,-1.645,25000,250,2,7137710.5909702331,null,3.13]
["Rural","Plains","Principal Arterial","R2",95,-1.645,7800,125,2]
["Rural","Mountains","Principal Arterial","R2",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial - Others","R2",95,-1.645,7800,125,2,3826673.0444254493,2126100.5530543365,4.28,7.5]
["Urban","Mountains","Principal Arterial - Others","R2",95,-1.645,25000,250,2,4460576.0404808773,null,2.91]
["Rural","Plains","Principal Arterial - Others","R2",95,-1.645,7800,125,2,3658426.9920592578,17093998.929864384,4.26,10.5]
["Rural","Mountains","Principal Arterial - Others","R2",95,-1.645,25000,250,2,3006165.984912077,null,2.73]
["Urban","Plains","Minor Arterial","R2",95,-1.645,7800,125,2,944941.51601856877,null,3.48]
["Urban","Mountains","Minor Arterial","R2",95,-1.645,25000,250,2,1267536.1380783783,null,2.38]
["Rural","Plains","Minor Arterial","R2",95,-1.645,7800,125,2,1090432.5239402903,null,3.55]
["Rural","Mountains","Minor Arterial","R2",95,-1.645,25000,250,2,721772.23115997063,null,2.17]
["Urban","Plains","Major Collector","R2",90,-1.282,7800,125,2,531929.91931229981,null,3]
["Urban","Mountains","Major Collector","R2",90,-1.282,25000,250,2]
["Rural","Plains","Major Collector","R2",90,-1.282,7800,125,2,454704.04472398764,300395.15944691026,2.93,"5.00*"]
["Rural","Mountains","Major Collector","R2",90,-1.282,25000,250,2,639982.64866947161,null,2]
["Urban","Plains","Minor Collector","R2",90,-1.282,7800,125,2.5]
["Urban","Mountains","Minor Collector","R2",90,-1.282,25000,250,2.5]
["Rural","Plains","Minor Collector","R2",90,-1.282,7800,125,2.5,138379.56047761784,null,2.39]
["Rural","Mountains","Minor Collector","R2",90,-1.282,25000,250,2.5,212073.52199380263,null,1.65]
["Urban","Plains","Local","R2",80,-0.84099999999999997,7800,125,2.5]
["Urban","Mountains","Local","R2",80,-0.84099999999999997,25000,250,2.5]
["Rural","Plains","Local","R2",80,-0.84099999999999997,7800,125,2.5]
["Rural","Mountains","Local","R2",80,-0.84099999999999997,25000,250,2.5]
["Urban","Plains","Interstate","R3",95,-1.645,8800,175,2,14303878.877041843,null,4.96]
["Urban","Mountains","Interstate","R3",95,-1.645,25000,250,2,14999191.523473265,19649107.867932573,3.51,10.5]
["Rural","Plains","Interstate","R3",95,-1.645,8800,175,2,13729143.361827856,23429679.525662627,4.93,11]
["Rural","Mountains","Interstate","R3",95,-1.645,25000,250,2,13566980.930517364,19224498.500492267,3.45,10.5]
["Urban","Plains","Principal Arterial","R3",95,-1.645,8800,175,2]
["Urban","Mountains","Principal Arterial","R3",95,-1.645,25000,250,2,3498379.7401503879,null,2.8]
["Rural","Plains","Principal Arterial","R3",95,-1.645,8800,175,2]
["Rural","Mountains","Principal Arterial","R3",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial - Others","R3",95,-1.645,8800,175,2,4159109.4017873663,6119289.4092848003,4.16,9]
["Urban","Mountains","Principal Arterial - Others","R3",95,-1.645,25000,250,2,2943067.7626122739,6350062.2283526063,2.72,8.75]
["Rural","Plains","Principal Arterial - Others","R3",95,-1.645,8800,175,2,2572820.0931703239,null,3.88]
["Rural","Mountains","Principal Arterial - Others","R3",95,-1.645,25000,250,2,2431662.6235348531,null,2.64]
["Urban","Plains","Minor Arterial","R3",95,-1.645,8800,175,2,1816911.3269019949,null,3.68]
["Urban","Mountains","Minor Arterial","R3",95,-1.645,25000,250,2]
["Rural","Plains","Minor Arterial","R3",95,-1.645,8800,175,2]
["Rural","Mountains","Minor Arterial","R3",95,-1.645,25000,250,2,760115.31442164956,null,2.19]
["Urban","Plains","Major Collector","R3",90,-1.282,8800,175,2,2070074.0937820959,null,3.41]
["Urban","Mountains","Major Collector","R3",90,-1.282,25000,250,2,1226296.092409224,null,2.23]
["Rural","Plains","Major Collector","R3",90,-1.282,8800,175,2,778552.69434648519,null,2.97]
["Rural","Mountains","Major Collector","R3",90,-1.282,25000,250,2,701247.45092509151,965521.85443660512,2.0299999999999998,5.75]
["Urban","Plains","Minor Collector","R3",90,-1.282,8800,175,2.5]
["Urban","Mountains","Minor Collector","R3",90,-1.282,25000,250,2.5]
["Rural","Plains","Minor Collector","R3",90,-1.282,8800,175,2.5]
["Rural","Mountains","Minor Collector","R3",90,-1.282,25000,250,2.5,144498.8975082025,null,1.54]
["Urban","Plains","Local","R3",80,-0.84099999999999997,8800,175,2.5]
["Urban","Mountains","Local","R3",80,-0.84099999999999997,25000,250,2.5]
["Rural","Plains","Local","R3",80,-0.84099999999999997,8800,175,2.5]
["Rural","Mountains","Local","R3",80,-0.84099999999999997,25000,250,2.5]
["Urban","Plains","Interstate","R4",95,-1.645,7800,125,2,18579164.408252276,46753639.765660666,5.34,12.25]
["Urban","Mountains","Interstate","R4",95,-1.645,25000,250,2]
["Rural","Plains","Interstate","R4",95,-1.645,7800,125,2,14879876.356701829,24623861.003986247,5.18,11.25]
["Rural","Mountains","Interstate","R4",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial","R4",95,-1.645,7800,125,2,8844608.7783379424,7969472.1510145646,4.83,9.25]
["Urban","Mountains","Principal Arterial","R4",95,-1.645,25000,250,2,7502156.398713924,11361775.445751509,3.15,9.75]
["Rural","Plains","Principal Arterial","R4",95,-1.645,7800,125,2,8193530.366803674,3582431.3343837098,4.7699999999999996,8.25]
["Rural","Mountains","Principal Arterial","R4",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial - Others","R4",95,-1.645,7800,125,2]
["Urban","Mountains","Principal Arterial - Others","R4",95,-1.645,25000,250,2,3133894.2479901551,7854895.3035780918,2.75,9]
["Rural","Plains","Principal Arterial - Others","R4",95,-1.645,7800,125,2,3467029.0510831894,13238864.221895907,4.22,10]
["Rural","Mountains","Principal Arterial - Others","R4",95,-1.645,25000,250,2,3276805.7688367283,8757033.2079158016,2.77,9.25]
["Urban","Plains","Minor Arterial","R4",95,-1.645,7800,125,2]
["Urban","Mountains","Minor Arterial","R4",95,-1.645,25000,250,2,1191445.2378031318,2158673.5221509892,2.35,7.25]
["Rural","Plains","Minor Arterial","R4",95,-1.645,7800,125,2]
["Rural","Mountains","Minor Arterial","R4",95,-1.645,25000,250,2,634776.05321932433,null,2.13]
["Urban","Plains","Major Collector","R4",90,-1.282,7800,125,2,1596289.7815853129,null,3.56]
["Urban","Mountains","Major Collector","R4",90,-1.282,25000,250,2,2498927.7095714347,null,2.5]
["Rural","Plains","Major Collector","R4",90,-1.282,7800,125,2,918757.73798497766,null,3.27]
["Rural","Mountains","Major Collector","R4",90,-1.282,25000,250,2,1849444.6115821067,null,2.38]
["Urban","Plains","Minor Collector","R4",90,-1.282,7800,125,2.5]
["Urban","Mountains","Minor Collector","R4",90,-1.282,25000,250,2.5]
["Rural","Plains","Minor Collector","R4",90,-1.282,7800,125,2.5,461164.66773682291,null,2.86]
["Rural","Mountains","Minor Collector","R4",90,-1.282,25000,250,2.5,62177.543836057244,null,1.32]
["Urban","Plains","Local","R4",80,-0.84099999999999997,7800,125,2.5]
["Urban","Mountains","Local","R4",80,-0.84099999999999997,25000,250,2.5]
["Rural","Plains","Local","R4",80,-0.84099999999999997,7800,125,2.5,604980.99328052439,null,2.79]
["Rural","Mountains","Local","R4",80,-0.84099999999999997,25000,250,2.5]
["Urban","Plains","Interstate","R5",95,-1.645,8800,175,2]
["Urban","Mountains","Interstate","R5",95,-1.645,25000,250,2]
["Rural","Plains","Interstate","R5",95,-1.645,8800,175,2]
["Rural","Mountains","Interstate","R5",95,-1.645,25000,250,2]
["Urban","Plains","Principal Arterial","R5",95,-1.645,8800,175,2,3259732.512926111,4157271.183313759,4.0199999999999996,8.5]
["Urban","Mountains","Principal Arterial","R5",95,-1.645,25000,250,2,3922137.0687339595,6226763.4353277767,2.85,8.75]
["Rural","Plains","Principal Arterial","R5",95,-1.645,8800,175,2,2567408.4718126366,null,3.88]
["Rural","Mountains","Principal Arterial","R5",95,-1.645,25000,250,2,2621243.6602242677,4935177.8012600448,2.67,8.5]
["Urban","Plains","Principal Arterial - Others","R5",95,-1.645,8800,175,2]
["Urban","Mountains","Principal Arterial - Others","R5",95,-1.645,25000,250,2]
["Rural","Plains","Principal Arterial - Others","R5",95,-1.645,8800,175,2]
["Rural","Mountains","Principal Arterial - Others","R5",95,-1.645,25000,250,2]
["Urban","Plains","Minor Arterial","R5",95,-1.645,8800,175,2]
["Urban","Mountains","Minor Arterial","R5",95,-1.645,25000,250,2,862074.29069383722,null,2.23]
["Rural","Plains","Minor Arterial","R5",95,-1.645,8800,175,2,682182.6204807394,null,3.16]
["Rural","Mountains","Minor Arterial","R5",95,-1.645,25000,250,2,719941.43923173065,665433.2153633259,2.17,5.75]
["Urban","Plains","Major Collector","R5",90,-1.282,8800,175,2]
["Urban","Mountains","Major Collector","R5",90,-1.282,25000,250,2]
["Rural","Plains","Major Collector","R5",90,-1.282,8800,175,2,285405.27432261256,null,2.6]
["Rural","Mountains","Major Collector","R5",90,-1.282,25000,250,2,669876.77900406439,null,1.75]
["Urban","Plains","Minor Collector","R5",90,-1.282,8800,175,2.5]
["Urban","Mountains","Minor Collector","R5",90,-1.282,25000,250,2.5]
["Rural","Plains","Minor Collector","R5",90,-1.282,8800,175,2.5,271011.49330390379,null,2.5299999999999998]
["Rural","Mountains","Minor Collector","R5",90,-1.282,25000,250,2.5,231348.29013545325,null,1.68]
["Urban","Plains","Local","R5",80,-0.84099999999999997,8800,175,2.5]
["Urban","Mountains","Local","R5",80,-0.84099999999999997,25000,250,2.5]
["Rural","Plains","Local","R5",80,-0.84099999999999997,8800,175,2.5]
["Rural","Mountains","Local","R5",80,-0.84099999999999997,25000,250,2.5]

{"sheet":"RoadwayCalcs","index":7,"n_rows":3,"n_cols":43,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["ID","Name","Start MP","End MP","LOC","TOPO","CLASS","REGION","Surface","Length","Width","Lanes","D#","Dev ESALs","Ex SI","Design ESALs","Ex Yr ESALs","Combo Dev ESALs","Terminal SI","Reliab %","SND\n ZR","Resilient Modulus","AASHTO Eq. - Ex.","Required SN - Ex.","Dev AASHTO\nEq. - Combo","Dev Required SN - Combo","Dev SN Deficiency","Dev Overlay In.","Development Improvement $","Future Prod ESALs","Combo Prod ESALs","Prod AASHTO\nEq. - Combo","Prod Required SN - Combo","Prod SN Deficiency","Prod Overlay In.","Ft. Production Improvement $","Existing Prod ESALs","Combo Prod ESALs","Prod AASHTO\nEq. - Combo","Prod Required SN - Combo","Prod SN Deficiency","Prod Overlay In.","Ex. Production Improvement $"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I2=\"Asphalt\", TruckDistribution!$M$163, IF(I2=\"Concrete\", TruckDistribution!$N$163, 0))","v":0},{"$f":"SUMIF(OtherRoadway!A:A, ROUND(M2, 0), IF(COUNTIF(OtherRoadway!D:D, G2)>0, OtherRoadway!B:B, OtherRoadway!C:C))+IF(ROUND(M2, 0) = 0, S2+0.00001, IF(ROUND(M2, 0) > 10, 4.5, 0))","v":1.0000000000000001E-5},{"$f":"SUMIFS(IF(I2=\"Asphalt\", RoadwayConstants!J:J, IF(I2=\"Concrete\", RoadwayConstants!K:K,  RoadwayConstants!Z:Z)), RoadwayConstants!A:A, E2, RoadwayConstants!B:B, F2, RoadwayConstants!C:C, G2, RoadwayConstants!D:D, H2)","v":0},{"$f":"P2/20","v":0},{"$f":"Q2+N2","v":0},{"$f":"SUMIFS(RoadwayConstants!I:I, RoadwayConstants!A:A, E2, RoadwayConstants!B:B, F2, RoadwayConstants!C:C, G2, RoadwayConstants!D:D, H2)","v":0},{"$f":"SUMIFS(RoadwayConstants!E:E, RoadwayConstants!A:A, E2, RoadwayConstants!B:B, F2, RoadwayConstants!C:C, G2, RoadwayConstants!D:D, H2)","v":0},{"$f":"SUMIFS(RoadwayConstants!F:F, RoadwayConstants!A:A, E2, RoadwayConstants!B:B, F2, RoadwayConstants!C:C, G2, RoadwayConstants!D:D, H2)","v":0},{"$f":"SUMIFS(RoadwayConstants!G:G, RoadwayConstants!A:A, E2, RoadwayConstants!B:B, F2, RoadwayConstants!C:C, G2, RoadwayConstants!D:D, H2)","v":0},{"$f":"LOG10(Q2)-U2*0.44-9.36*LOG10(X2+1)+0.2-(LOG10((O2-S2)/(4.2-1.5))/(0.4+(1094/((X2+1)^5.19))))-2.32*LOG10(V2)+8.07","v":{"$error":"#NUM!"}},null,{"$f":"LOG10(R2)-U2*0.44-9.36*LOG10(Z2+1)+0.2-(LOG10((O2-S2)/(4.2-1.5))/(0.4+(1094/((Z2+1)^5.19))))-2.32*LOG10(V2)+8.07","v":{"$error":"#NUM!"}},null,{"$f":"Z2-X2","v":0},{"$f":"AA2/0.44","v":0},{"$f":"ROUNDUP(IF(I2=\"Asphalt\", 0.055*AB2*J2*K2*5280*(1/9)*OtherRoadway!$G$2, IF(I2=\"Concrete\", (N2/P2)*J2*L2*OtherRoadway!$G$3, 0)), -2)","v":0},{"$f":"IF($I2=\"Asphalt\", TruckDistribution!$M$67, IF($I2=\"Concrete\", TruckDistribution!$N$67, 0))","v":0},{"$f":"AD2+$Q2","v":0},{"$f":"LOG10(AE2)-U2*0.44-9.36*LOG10(AG2+1)+0.2-(LOG10((O2-S2)/(4.2-1.5))/(0.4+(1094/((AG2+1)^5.19))))-2.32*LOG10(V2)+8.07","v":{"$error":"#NUM!"}},null,{"$f":"AG2-$X2","v":0},{"$f":"AH2/0.44","v":0},{"$f":"ROUNDUP(IF(I2=\"Asphalt\", 0.055*AI2*J2*K2*5280*(1/9)*OtherRoadway!$G$2, IF(I2=\"Concrete\", (AD2/P2)*J2*L2*OtherRoadway!$G$3, 0)), -2)","v":0},{"$f":"IF($I2=\"Asphalt\", TruckDistribution!$M$75, IF($I2=\"Concrete\", TruckDistribution!$N$75, 0))","v":0},{"$f":"AK2+$Q2","v":0},{"$f":"LOG10(AL2)-U2*0.44-9.36*LOG10(AN2+1)+0.2-(LOG10((O2-S2)/(4.2-1.5))/(0.4+(1094/((AN2+1)^5.19))))-2.32*LOG10(V2)+8.07","v":{"$error":"#NUM!"}},null,{"$f":"AN2-$X2","v":0},{"$f":"AO2/0.44","v":0},{"$f":"ROUNDUP(IF(I2=\"Asphalt\", 0.055*AP2*J2*K2*5280*(1/9)*OtherRoadway!$G$2, IF(I2=\"Concrete\", (AK2/P2)*J2*L2*OtherRoadway!$G$3, 0)), -2)","v":0}]
["END"]

{"sheet":"BridgeConstants","index":8,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Deck","Years","$/SF","$/SF/Yr","Joints","Years","$/LF","$/LF/Yr","Bearings","Years","$/Each","$/Each/Yr","Replacement","Years","$/SF","$/SF/Yr"]
["Replacement",{"$f":"IF(Inputs!G49=\"No Overlay\", 30, 40)","v":40},42,{"$f":"C2/B2","v":1.05},"No Joints",0,0,0,"No Bearings",0,0,0,"Replacement",75,120,{"$f":"O2/N2","v":1.6}]
["HMA/Membrane",15,8,{"$f":"C3/B3","v":0.53333333333333333},"Plug Joint",15,400,{"$f":"G3/F3","v":26.666666666666668},"Type 1",30,5600,{"$f":"K3/J3","v":186.66666666666666}]
["Polyester",25,16,{"$f":"C4/B4","v":0.64},"0-4 inch",15,560,{"$f":"G4/F4","v":37.333333333333336},"Type 2",30,8000,{"$f":"K4/J4","v":266.66666666666669}]
["No Overlay",0,0,0,"Modular",25,3600,{"$f":"G5/F5","v":144},"Type 3",30,12000,{"$f":"K5/J5","v":400}]

{"sheet":"BridgeCalcs","index":9,"n_rows":3,"n_cols":38,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["ID","Structure #","Facility Carried","Feature Intersected","Baseline ADTT","Width","Length","Overlay","Joint\nType","Joints","Skew","Bearing\nType","Bearings","Replacement\nMethod","%\nIncrease","Repl.\nWidth","Repl.\nLength","Total Deck Area (SF)","Total Joint Length (LF)","Replacement Bridge Area (SF)","Dev\nO&G Trucks","Dev\nTrucks/Day","% Dev\nImpact","Deck Repl. $","Deck Overlay $","Joints Repl. $","Bearings Repl. $","Repl. Bridge $"," Total Bridge $","O&G Dev $","Ft. Prod\nO&G Trucks","Ft. Prod\nTrucks/Day","% Ft. Prod\nImpact","O&G Ft. Prod $/yr","Ft. Prod\nO&G Trucks","Ft. Prod\nTrucks/Day","% Ft. Prod\nImpact","O&G Ft. Prod $/yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F2*G2","v":0},{"$f":"J2*F2/COS(K2*PI()/180)","v":0},{"$f":"IF(N2=\"% Increase\", R2*(1+O2), P2*Q2)","v":0},{"$f":"TruckDistribution!$L$163","v":12370},{"$f":"IF(Inputs!$G$87 = 0, U2/30, U2/Inputs!$G$87)","v":412.33333333333331},{"$f":"IF($E2=0,1,V2/(V2+$E2))","v":1},{"$f":"BridgeConstants!$D$2*R2","v":0},{"$f":"SUMIF(BridgeConstants!A:A, H2, BridgeConstants!D:D)*R2","v":0},{"$f":"SUMIF(BridgeConstants!E:E, I2, BridgeConstants!H:H)*S2","v":0},{"$f":"SUMIF(BridgeConstants!I:I, L2, BridgeConstants!L:L)*M2","v":0},{"$f":"BridgeConstants!$P$2*T2","v":0},{"$f":"SUM(X2:AB2)","v":0},{"$f":"ROUND(AC2*W2, -2)","v":0},{"$f":"TruckDistribution!$L$67","v":560},{"$f":"AE2/365","v":1.5342465753424657},{"$f":"IF($E2=0,1,AF2/(AF2+$E2))","v":1},{"$f":"ROUND($AC2*AG2, -2)","v":0},{"$f":"TruckDistribution!$L$75","v":0},{"$f":"AI2/365","v":0},{"$f":"IF($E2=0,1,AJ2/(AJ2+$E2))","v":1},{"$f":"ROUND($AC2*AK2, -2)","v":0}]
["END"]

{"sheet":"OtherRoadway","index":10,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["#","SI-Maj","SI-Min","Class-Maj","Class-Min","Surface","Cost","Unit"]
[1,2.7,3,"Interstate","Minor Collector","Asphalt",155,"Ton"]
[2,2.7,3,"Principal Arterial","Local","Concrete",572725,"Lane/Mile"]
[3,3.3,3.5,"Principal Arterial - Others"]
[4,3.3,3.5,"Minor Arterial"]
[5,3.3,3.5,"Major Collector"]
[6,3.3,3.5]
[7,3.3,3.5]
[8,3.3,3.5]
[9,4,4]
[10,4,4]